MVCC Unmasked

Talk Type: 
90 Minute Mini-Tutorial
Track: 
Other
Technical Level: 
Advanced
License: 
Creative Commons - Attribution Only

Multiversion Concurrency Control (MVCC) allows Postgres to offer high concurrency even during significant database read/write activity. MVCC specifically offers behavior where "readers never block writers, and writers never block readers". This talk explains how MVCC is implemented in Postgres and highlights optimizations which minimize the downsides of MVCC. This talk is for advanced users.