Maintenance
Database maintenance tasks, vacuum strategies, and bloat management
How-to guides​
How to deal with long-running transactions (OLTP)​
Identify and handle long-running transactions that can impact OLTP system performance
Difficulty: beginner • Time: 6 min
How to use subtransactions in Postgres​
Understand subtransactions, savepoints, and their impact on database performance
Difficulty: beginner • Time: 5 min
How to deal with bloat​
Detect, measure, and eliminate table and index bloat to maintain database health
Difficulty: intermediate • Time: 5 min
Autovacuum "queue" and progress​
Monitor and manage autovacuum queue, understand worker activity and vacuum progress
Difficulty: intermediate • Time: 5 min
How to run ANALYZE (to collect statistics)​
Difficulty: beginner • Time: 5 min
How to enable data checksums without downtime​
Difficulty: advanced • Time: 7 min
How to troubleshoot and speed up Postgres stop and restart attempts​
Difficulty: intermediate • Time: 5 min
How to troubleshoot long Postgres startup​
Difficulty: intermediate • Time: 5 min
How to troubleshoot a growing pg_wal directory​
Difficulty: intermediate • Time: 6 min