MVCC Unmasked

Talk Type: 

90 Minute Mini-tutorial

Technical Level: 
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.

mvcc.pdf413.22 KB