Learning path
Vacuum, Bloat & Wraparound
MVCC, dead tuples, autovacuum tuning, bloat and the xid-wraparound emergency.
DBA, SRE · Advanced · 2 courses · 11 simulations
The path
Courses, then incidents
Work through the courses, then practise the incidents — each step links to its page.
- Course MVCC and VACUUM →
- Course Autovacuum, Bloat and Freeze →
- vacuum-bloat Autovacuum starvation in a tenant database →
- vacuum-bloat Table bloat after update churn →
- vacuum-bloat Index bloat after churn →
- vacuum-bloat Long transaction prevents cleanup →
- vacuum-bloat Dead tuples growth →
- vacuum-bloat Vacuum cost-delay misconfiguration →
- vacuum-bloat Freeze age warning →
- vacuum-bloat XID wraparound emergency simulation →
- vacuum-bloat REINDEX needed →
- vacuum-bloat Unsafe VACUUM FULL capstone →
- locks-transactions VACUUM FULL takes an exclusive lock →