Some Tips and Tricks about PostgreSQL.
- Get content statistics for a table
- Check a fillfactor value for tables and indexes
- Find duplicate indexes
- Find useless indexes
- Get the table structure
- Get index usage statistics
- Tables needing indexes
- Returns all non-system tables missing a primary key and (or) unique indexes
- Returns all non-system tables on which a primary key is missing
- Returns all tables with Geometry fields that have no index on the Geometry field
- Find bloated tables
- Find missing indexes
- Checking the size of the database
- Get wasted bytes
- Which table has the highest dead tuples
- Which table or index is consuming the most space
- PostgreSQL SQL Tricks - Tips & Tricks on PostgreSQL
- PostgreSQL Index Maintenance - Index maintenance
- Postgres Cheat Sheet - PGSQL cheat sheet
- PGSQL commands & queries - Useful commands & queries
- pgwatch - PG monitoring tool
- pg_configurator - Configurating PG
- pg_squeeze - Shrink PG tables
- pgTAP - Unit testing for PostgreSQL
- Git - Open source distributed version control system
If you would like to contribute, read the CONTRIBUTING.md file to learn how to do so.