Concept
MVCC
Multi-version concurrency control lets readers and writers work at the same time without blocking each other. An update does not overwrite a row: it adds a new version, and each transaction sees the versions that were current when it began. Old versions have to be cleaned up later, and a transaction left open stops that cleanup.
Where you'll see it
Related concepts
Sources: PostgreSQL documentation: concurrency control (MVCC) ↗ · PostgreSQL documentation: routine vacuuming ↗ · Stripe: Online migrations at scale ↗ · Report a problem
The definition is in our own words; the sources are those of the lesson MVCC.