Glossary term
What is MVCC (Multi-Version Concurrency Control)?
MVCC stands for Multi-Version Concurrency Control.
In System Design
Keeps several versions of rows so readers don't block writers. Example: PostgreSQL shows each transaction a consistent snapshot.
Learn it properly · System DesignLesson 21: ACID Transactions & Isolation LevelsTwo people book the last seat; a transfer crashes halfway. What ACID really promises, the write-ahead log behind durability, the five anomalies isolation levels do (and don't) prevent, and the practical fixes for real race conditions.In Full-Stack Questions
How PostgreSQL lets readers and writers work together by keeping several versions of a row.
Learn it properly · Full-Stack QuestionsLesson 27: SEO, i18n, PWA and PostgreSQL DeeperNext.js metadata and sitemaps, locale routing and plurals, service workers, window functions, JSONB, EXPLAIN, locks, vacuum and PgBouncer.