series
A series which helps you to understand the PostgreSQL as a whole. Gives you idea about it's architecture and high-level working (a little depth) knowledge
Learn how PostgreSQL manages backend processes, the postmaster, shared buffers, and memory contexts. A deep dive into PG's process and memory model.
2026-03-28 · 8 min read
Explore how PostgreSQL stores data on disk - 8KB heap pages, item pointers, tuple headers, TOAST, and the free space map.
2026-04-01 · 13 min read
Understand how PostgreSQL implements MVCC using xmin/xmax, snapshot isolation, and visibility rules - with all four transaction isolation levels explained.
2026-04-06 · 12 min read
Deep dive into PostgreSQL's Write-Ahead Logging - how WAL records are written, what checkpoints do, and how crash recovery uses REDO to restore state.
2026-04-12 · 14 min read
Trace a SQL query through PostgreSQL's full pipeline - from raw text through the parser, rewriter, planner, and executor with internals at each stage.
2026-04-21 · 16 min read
Deep dive into index internals: B-tree page format, split algorithm, GIN posting lists, BRIN range summaries, and how the planner picks between the Indexes.
2026-05-02 · 16 min read
Inside PostgreSQL VACUUM: dead tuple collection, OldestXmin watermark, autovacuum triggers, XID freeze mechanics, bloat diagnosis, and pg_repack vs VACUUM FULL.
2026-05-12 · 13 min read
PostgreSQL locking deep dive: lock hierarchy, row-level locks in xmax, MultiXactId, deadlock detection, advisory locks, SKIP LOCKED queue, and pg_locks queries.
2026-05-25 · 14 min read
Final blog post of the PostgreSQL Internals series explaining about Replication and it's type i.e., Physical and Logical Replication.
2026-07-17 · 12 min read