Skip to main content

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