90 Minute Mini-tutorial
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.