Transactions, MVCC and Locking
A single-node transaction is hard enough. This part covers what changes when a transaction spans every segment in the cluster.
-
Chapter 10
MVCC, Snapshots and Vacuum in Apache Cloudberry
Row visibility, the transaction horizon, distributed snapshots and the distributed log, freezing and XID wraparound, and rebuilding tables and indexes.
-
Chapter 11
Locks and the Global Deadlock Detector in Cloudberry
Heavyweight and row-level locks, multixacts, local deadlock detection, and the global deadlock detector that makes cross-segment deadlocks survivable.