PostgreSQL Skills Development on Cloud: A Practical Guide to Database Management with AWS and Azure

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024

V. VadlamaniPostgreSQL Skills Development on Cloudhttps://doi.org/10.1007/979-8-8688-0817-3_17

17. MVCC

Venkateswara Vadlamani¹  

(1)

Rancho Palos Verdes, CA, USA

 

17.1 Abstract

The core competency of the database engine is gauged by its adherence to multi-version concurrency control (MVCC) transaction processing procedures and protocols. MVCC enables multiple user transactions to access the data concurrently for select, insert, update, and delete operations using ANSI-compliant isolation levels, which include READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, or SERIALIZABLE. Dirty reads are possible with READ UNCOMMITTED transactions, whereas READ COMMITTED ...