Skip to content

Glossary: PostgreSQL Beyond the Basics

Frozen, wraparound

Also written: transaction ID, wraparound, frozen, datfrozenxid

Every transaction gets a number, and the counter wraps around after about 2 billion. VACUUM marks old rows frozen so they stay visible after wraparound. If VACUUM falls behind, Postgres stops accepting writes.

Where the book teaches it

Related terms

VACUUMAutovacuum