PostgreSQL

Disabled autovacuum prevents transaction ID freezing and leads to wraparound

critical
configurationUpdated Feb 13, 2026
Technologies:
How to detect:

Disabling autovacuum on tables prevents transaction ID freezing. Transaction IDs age silently at rate of write transactions per day. With 10 TPS workload, wraparound threshold (200M) reached in ~231 days. No performance degradation until sudden failure.

Recommended action:

Never disable autovacuum permanently. If temporarily disabled for performance issues, re-enable immediately after resolution. Monitor age(relfrozenxid) on all tables, especially those with autovacuum disabled. Calculate time-to-wraparound: 200,000,000 ÷ (transactions_per_second × 86400).