PGCon2011 - Add 4 Video (2015.09.18)

PGCon 2011
The PostgreSQL Conference

Bruce Momjian
Day Talks - 1 - 2011-05-19
Room DMS 1120
Start time 11:30
Duration 02:00
ID 297
Event type Lecture
Track Advanced Features
Language used for presentation English

MVCC Unmasked

Multi-Version 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.

This is a two hour talk which extends into lunch. There will be a short break to allow people to grab lunch and bring it back into the lecture hall.