MVCC

From PostgreSQL wiki

Revision as of 18:42, 19 May 2012 by Boshomi (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

MVCC is the method PostgreSQL uses to handle data consistency when multiple processes are accessing the same table. The manual documents it in the chapter on Concurrency Control.

There is a good example of how MVCC works in the PostgreSQL Through Pictures presentation, on pages 56-58, and a long discussion in the MVCC Unmasked presentation.

MVCC is not unique to PostgreSQL, it's a common database technique.

Personal tools