Definition
Multi-Version Concurrency Control: keep multiple versions so readers never block writers.
How it works
Each transaction reads a consistent snapshot; the basis of Snapshot Isolation in Postgres/Oracle.
Common questions
What is MVCC?
Multi-Version Concurrency Control: keep multiple versions so readers never block writers.
How does MVCC work?
Each transaction reads a consistent snapshot; the basis of Snapshot Isolation in Postgres/Oracle.
What is MVCC used for in system design?
Each transaction reads a consistent snapshot; the basis of Snapshot Isolation in Postgres/Oracle.
Part of Glossary on SystemLore — system design explained with 148 deep topics, interactive diagrams, and a build-it-yourself game. Build this one →