MVCC Unmasked

Data: Relational
Location: C121/122
Tags: dba_dude
Presentation: MVCC Unmasked Presentation [PDF]
Average rating: ****.
(4.00, 1 rating)

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.

Photo of Bruce Momjian

Bruce Momjian


Bruce Momjian is a co-founder of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Bruce is employed by EnterpriseDB. Previously, he was employed by SRA Japan and Great Bridge LLC, both PostgreSQL support companies. He has spoken at many international open-source conferences. Prior to his involvement with PostgreSQL, Bruce worked as a consultant, developing custom database applications for some of the world’s largest law firms. As an academic, Bruce was a high school computer science teacher for five years, holds a Masters in Education, and is currently an adjunct professor at Drexel University.

Comments on this page are now closed.


Picture of Sheeri K. Cabral
Sheeri K. Cabral
09/04/2011 10:04pm PDT

Video for this talk can be found at