Skip to content

Glossary: PostgreSQL Beyond the Basics

MVCC

Also written: multiversion concurrency control, xmin, xmax

Multiversion concurrency control: an UPDATE writes a new row version instead of overwriting. Readers and writers therefore don't block each other, and only two writers to the same row wait. `xmin` and `xmax` are hidden columns showing which transactions created and replaced a version.

Where the book teaches it

Related terms

Row version, snapshotDead row, bloat