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