postgres_dba
blog
postgres_dba | blog | |
---|---|---|
1 | 1 | |
974 | 7,836 | |
- | - | |
1.7 | 9.9 | |
11 months ago | 8 days ago | |
PLpgSQL | PLpgSQL | |
BSD 3-clause "New" or "Revised" License | GNU General Public License v3.0 only |
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
-
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.
blog
What are some alternatives?
AGE-Machine-Learning - A project that uses Incubating Apache AGE to implment machine learning algorithms
crystal - 🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more!
advent-of-code - https://adventofcode.com/
postgres-aws-s3 - aws_s3 postgres extension to import/export data from/to s3 (compatible with aws_s3 extension on AWS RDS)
omdb-postgresql - PostgreSQL Schema for OMDB
employee-sample-database - Employee Sample Database for MySQL and Postgres
database-lab-engine - DBLab enables 🖖 database branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software quality. Follow to stay updated.
aurora - CLI tool that orchestrates prisma files in a way that allows multiple .prisma files with cross-relations
pgddl - DDL eXtractor functions for PostgreSQL (ddlx)
Directus - The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
pg_partman - Partition management extension for PostgreSQL