PGCon2011 - Add 4 Video (2015.09.18)
PGCon 2011
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Bruce Momjian |
| Schedule | |
|---|---|
| Day | Talks - 1 - 2011-05-19 |
| Room | DMS 1120 |
| Start time | 11:30 |
| Duration | 02:00 |
| Info | |
| 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.