# SE Radio 496: Bruce Momjian on Multi-Version Concurrency Control in Postgres (MVCC)

An episode of [Software Engineering Radio - the podcast for professional software developers](https://invisiblenetwork.ai/podcast/120906714), 25 Jan 2022, 1 h 00 min.

Audio: https://traffic.libsyn.com/secure/seradio/496-bruce-momjian-multi-version-concurrency-control-postgres.mp3?dest-id=23379

This week, Postgres server developer Bruce Momjian joins host Robert Blumen for a discussion of multi-version concurrency control (MVCC) in the Postgres database. They begin with a discussion of the isolation requirement in database transactions (I in ACID); how isolation can be achieved with locking; limitations of locking; how locking limits concurrency and creates variability in query runtimes; multi-version concurrency control as a means to achieve isolation; how Postgres manages multiple versions of a row; snapshots; copy-on-write and snapshots; visibility; database transaction IDs; how tx ids, snapshots and versions interact; the need for locking when there are multiple writers; how MVCC was added to Postgres; and how to clean up unused space left over from aged-out versions.

Shows are listed from Apple Podcasts' charts and directory, and Podcast Index where it is used. Every show and episode belongs to its publisher and plays from the publisher's own feed; this site hosts none of them.
