Jump to content

Multi-Version Concurrency Control

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Jamesday (talk | contribs) at 14:52, 17 July 2005 (Replace with a simpler and more accurate description, since this isn't wondrous new PostgreSQL technology, just a standard SQL-92 feature.). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Multi-Version Concurrency Control is the term used by the PostgreSQL database for the SQL-92 "read uncommitted" transaction isolation level, one of the four defined isolation levels "read committed", "repeatable read" and "serializable". The "read uncommitted" transaction isolation level causes a transaction to read the table without waiting for lock, supplying possibly out of date information but not being delayed by the need to wait for the lock to end.