Administration
Essential guides for PostgreSQL database administrators covering maintenance, backups, and configuration.
Guides by Category
Backups, data export/import
Master backup strategies, disaster recovery, and data transfer techniques.
- How to speed up pg_dump when dumping large databases - 8 min (advanced)
- How to use pg_restore - 6 min (intermediate)
- How to speed up bulk load - 5 min (intermediate)
Configuration
Optimize PostgreSQL settings for your workload and hardware.
- How to perform initial / rough Postgres tuning - 5 min (beginner)
- How to tune Linux parameters for OLTP Postgres - 5 min (beginner)
- Rough configuration tuning (80/20 rule; OLTP) - 5 min (beginner)
- How to tune work_mem - 5 min (intermediate)
- How to change Postgres parameters - 5 min (beginner)
Maintenance
Learn vacuum strategies, bloat management, and routine maintenance tasks.
- How to deal with long-running transactions (OLTP) - 6 min (beginner)
- How to use subtransactions in Postgres - 5 min (beginner)
- How to deal with bloat - 5 min (intermediate)
- Autovacuum "queue" and progress - 5 min (intermediate)
- How to run ANALYZE (to collect statistics) - 5 min (beginner)
- How to enable data checksums without downtime - 7 min (advanced)
- How to troubleshoot and speed up Postgres stop and restart attempts - 5 min (intermediate)
- How to troubleshoot long Postgres startup - 5 min (intermediate)
- How to troubleshoot a growing pg_wal directory - 6 min (intermediate)