Downtime Caused by the Postgres Transaction ID Wraparound Problem
Summary
The article explains a real PostgreSQL outage caused by transaction ID wraparound, a silent risk where old XIDs must be frozen to prevent reuse. It describes how autovacuum misconfiguration allowed aging to accumulate, triggering a sudden write blocking state, and details the recovery steps and lessons for production databases.