Skip to content

About Projects Blog Now Contact

say hello

Let's talk.

© 2026 Samba Siva Reddy. All rights reserved.

Blog

Writing on PostgreSQL internals, databases and systems, plus the occasional piece on books and personal growth.

Artificial Intelligence2

Series

PostgreSQL Internals

A series on understanding what is really happening under the hood of postgreSQL

Monthly Books Summary

A series on monthly summary of the books I read in that month

October 2026

WAL - How PostgreSQL remembers everything it was about to do

Reading PostgreSQL

October 4, 2026·22 min read

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.

WAL - How PostgreSQL remembers everything it was about to do

August 2026

The Anatomy of Query Structure

Reading PostgreSQL

August 28, 2026·13 min read

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.

The Anatomy of Query Structure

Vacuum - PostgreSQL way of clearing it's Debt

Reading PostgreSQL

August 8, 2026·10 min read

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.

Vacuum - PostgreSQL way of clearing it's Debt

June 2026

PostgreSQL Table Statistics: When, Where, and How They're Calculated

Reading PostgreSQL

June 22, 2026·7 min read

PostgreSQL Table Statistics: When, Where, and How They're Calculated

Understand and Learn about the PostgreSQL Table's Statistics and in-depth code walkthrough

PostgreSQL Table Statistics: When, Where, and How They're Calculated

TableAmRoutine - your way of integrating a custom storage engine into PostgreSQL

Reading PostgreSQL

June 13, 2026·6 min read

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.

963🔥2🧠1👏1

TableAmRoutine - your way of integrating a custom storage engine into PostgreSQL

Stay Updated

Get notified when I publish new articles. No spam, unsubscribe anytime.

By subscribing, you agree to our Privacy Policy.

Book Review

A few reviews on Books I really loved