Skip to content

Writing Projects About

New posts by email, roughly twice a month. Subscribe or RSS

now life log contact resume privacy

© 2026 Samba Siva Reddy · served from PostgreSQL · \q

← writing/series

series

Reading PostgreSQL

Walking through PostgreSQL concepts directly from the source code, complements to the PostgreSQL Internals series

6 parts · 74 min

Share:

1
TableAmRoutine - your way of integrating a custom storage engine into PostgreSQL
Learn how TableAmRoutine works under the hood and use it to plug your custom storage engine into PostgreSQL without touching the core.
2026-06-13 · 6 min read
2
PostgreSQL Table Statistics: When, Where, and How They're Calculated
Understand and Learn about the PostgreSQL Table's Statistics and in-depth code walkthrough
2026-06-22 · 7 min read
3
Vacuum - PostgreSQL way of clearing it's Debt
Vacuum in PostgreSQL helps reclaiming the space occupied by dead tuples. Here in this blog, we discusses about how Vacuum do in PostgreSQL internally.
2026-08-08 · 10 min read
4
The Anatomy of Query Structure
How PostgreSQL represents SQL internally: a field-by-field tour of the Query struct, from range tables and target lists to joins, grouping, and permissions.
2026-08-28 · 13 min read
5
WAL - How PostgreSQL remembers everything it was about to do
Follow one change through PostgreSQL's Write-Ahead Log, from a modified page to crash replay, reading the PostgreSQL 18 source and verifying each step with pg_waldump.
2026-10-04 · 24 min read
6
Reading PostgreSQL: MVCC Internals, from Snapshots to HeapTupleSatisfiesMVCC
How PostgreSQL decides which row version you see: tuple headers, snapshots, and a line-by-line walk through HeapTupleSatisfiesMVCC.
2026-10-31 · 14 min read