← recall

transaction id wraparound term

Postgres XID exhaustion forces emergency vacuum

Postgres XIDs are 32-bit. As they approach exhaustion, autovacuum gets aggressive. If it can't keep up, the database refuses writes to prevent data loss.

aliases: xid wraparound, wraparound

topics: databases, postgres, failure-modes

references:

• Postgres — Preventing Transaction ID Wraparound
• Sentry — How a single bad XID caused incident