11h ago · 9 min read · Lets Dissect HeapTupleFields. “PostgreSQL tracks five MVCC fields using only three storage slots — by letting multiple fields share the same space.” 1️⃣ Concept — Why do we need cmin & cmax? Postgr
Join discussionFeb 12 · 11 min read · The Fundamental Problem with Traditional Locking Traditional pessimistic locking forces readers to wait for writers and writers to wait for readers, creating a serialization point that destroys throughput. In a system processing 50,000 transactions p...
Join discussionSep 13, 2025 · 4 min read · PostgreSQL implements MVCC (Multi-Version Concurrency Control) so that transactions see a consistent view of data while minimizing blocking.This design is central to PostgreSQL’s ability to balance consistency with concurrency. Tuple metadata: xmin ...
Join discussionOct 11, 2024 · 3 min read · Introduction PostgreSQL uses Multi-Version Concurrency Control (MVCC) to provide high concurrency and ensure data consistency by creating multiple versions of a row rather than using a traditional locking mechanism for every read and write. This appr...
Join discussion
Apr 7, 2023 · 5 min read · PostgreSQL is a very popular open-source object-relational database system that uses a unique approach to handle concurrency called Multi-Version Concurrency Control (MVCC). Let's explore what MVCC is, how it works, and why it is essential for Postgr...
Join discussion
