postgres_dba
The missing set of useful tools for Postgres DBAs and all engineers (by NikolayS)
postgres-aws-s3
aws_s3 postgres extension to import/export data from/to s3 (compatible with aws_s3 extension on AWS RDS) (by chimpler)
| postgres_dba | postgres-aws-s3 | |
|---|---|---|
| 3 | 1 | |
| 1,194 | 168 | |
| 0.6% | 2.4% | |
| 2.5 | 0.0 | |
| 24 days ago | over 1 year ago | |
| PLpgSQL | PLpgSQL | |
| BSD 3-clause "New" or "Revised" License | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
postgres_dba
Posts with mentions or reviews of postgres_dba.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-06-12.
-
Optimizing Postgres table layout for maximum efficiency
The ever-useful postgres_dba extension (https://github.com/NikolayS/postgres_dba) can help with this. Install the extension, start psql, run :dba and choose option p1 to see how much table space you would save by reordering your columns.
-
How to Get the Most Out of Postgres Memory Settings
This is even handier: https://github.com/NikolayS/postgres_dba
-
Postgres: The Unexpected Find That Freed 20GB of Unused Index Space
In a similar vein, I got good value from these scripts:
https://github.com/NikolayS/postgres_dba
I managed to free 10% a.k.a about 100 GB of storage by reorganizing table column ordering in a big table.
postgres-aws-s3
Posts with mentions or reviews of postgres-aws-s3.
We have used some of these posts to build our list of alternatives
and similar projects.
-
ETL/ELT thoughts for a PostgreSQL data warehouse
i found https://github.com/chimpler/postgres-aws-s3 and few others. No idea which one is most popular or well maintained extension. RDS aws_s3 seems to be amazon RDS only solution.
What are some alternatives?
When comparing postgres_dba and postgres-aws-s3 you can also consider the following projects:
employee-sample-database - Employee Sample Database for MySQL, Postgres, SQLite
periods - PERIODs and SYSTEM VERSIONING for PostgreSQL
AGE-Machine-Learning - A project that uses Incubating Apache AGE to implment machine learning algorithms
blog - Opensource,Database,AI,Business,Minds. git clone --depth 1 https://github.com/digoal/blog
advent-of-code - https://adventofcode.com/
terraform-aws-rds - Terraform module to provision AWS RDS instances