Runbook category
Vacuum & bloat
MVCC leaves dead row versions behind, and vacuum is what clears them. These runbooks cover the whole failure surface: vacuum that runs but reclaims nothing, autovacuum thresholds that are far too lax for a hot table, TOAST and index bloat that the main heap size never shows, and the two wraparound counters that can stop a cluster outright.
- Free
Reclaim table bloat: plain VACUUM vs VACUUM FULL
The table file is far bigger than the live data and VACUUM does not shrink it.
- Pro
Rebuild a bloated index with REINDEX CONCURRENTLY
The index is four times the size of its entries and scans keep getting slower.
- Pro
Tame autovacuum on a high-churn table
A hot table reaches six figures of dead rows before autovacuum even considers it.
- Pro
Unblock vacuum held back by a long transaction
VACUUM runs, reports rows not yet removable, and the bloat never goes down.
- Pro
Preempt transaction ID wraparound
Transaction age climbs toward two billion and nothing is freezing the old rows.
- Pro
Find tables autovacuum keeps skipping
One table bloats forever, autovacuum never touches it, and nothing warns you.
- Pro
Shrink TOAST bloat from wide rows
Heap size looks healthy; the disk filled because the TOAST table grew five-fold.
- Pro
Assess multixact wraparound risk
A second wraparound counter nobody monitors until the cluster stops accepting writes.