Samba.dev
AboutProjectsBlogNow
Samba Siva Reddy

Software Engineer building scalable systems and sharing knowledge through code and writing.

Pages

  • About
  • Projects
  • Blog
  • Contact
  • Resume
  • Privacy Policy

Connect

© 2026 Samba Siva Reddy. All rights reserved.

Blog

✉ Subscribe

Thoughts on software engineering, web development, technology, books, personal growth, and more.

27 articles·1.2k reads·14 tags
All
Artificial Intelligence (2)
Personal (8)
PostgreSQL (11)
Productivity (1)
Technical (18)
Thoughts (1)
Clear filter

Series

PostgreSQL Internals

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

8 parts

Monthly Books Summary

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

3 parts

Book Review

A few reviews on Books I really loved

1 part

Rust Basics

A series to learn the Rust Basics

June 2026

1
Reading PostgreSQL · Part 2
June 22, 2026·7 min readNew

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
Technical
PGSourceCode
102
2
Reading PostgreSQL · Part 1
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.

PostgreSQL
Technical
PGSourceCode
1533

May 2026

3
PostgreSQL Internals · Part 8
May 25, 2026·14 min read

PostgreSQL Internals - Module 8: Concurrency & Locking

PostgreSQL locking deep dive: lock hierarchy, row-level locks in xmax, MultiXactId, deadlock detection, advisory locks, SKIP LOCKED queue, and pg_locks queries.

PostgreSQL
Technical
PGInternals
311
4
PostgreSQL Internals · Part 7
May 12, 2026·13 min read

PostgreSQL Internals - Module 7: VACUUM, Autovacuum & Bloat

Inside PostgreSQL VACUUM: dead tuple collection, OldestXmin watermark, autovacuum triggers, XID freeze mechanics, bloat diagnosis, and pg_repack vs VACUUM FULL.

PostgreSQL
Technical
PGInternals
2611
5
PostgreSQL Internals · Part 6
May 2, 2026·16 min read

PostgreSQL Internals - Module 6: Indexing Internals

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.

PostgreSQL
Technical
PGInternals
4221

April 2026

6
PostgreSQL Internals · Part 5
April 21, 2026·16 min read

PostgreSQL Internals - Module 5: Query pipeline

Trace a SQL query through PostgreSQL's full pipeline - from raw text through the parser, rewriter, planner, and executor with internals at each stage.

PostgreSQL
Technical
PGInternals
5862
7
PostgreSQL Internals · Part 4
April 12, 2026·14 min read

PostgreSQL Internals - Module 4: Write-Ahead Logging, Checkpoints and Crash Recovery

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.

PostgreSQL
Technical
PGInternals
7042
8
PostgreSQL Internals · Part 3
April 6, 2026·10 min read

PostgreSQL Internals - Module 3: MVCC & Transaction Isolation Levels

Understand how PostgreSQL implements MVCC using xmin/xmax, snapshot isolation, and visibility rules - with all four transaction isolation levels explained.

PostgreSQL
Technical
PGInternals
5871
9
PostgreSQL Internals · Part 2
April 1, 2026·13 min readPopular

PostgreSQL Internals - Module 2: Page Layout & Storage Internals

Explore how PostgreSQL stores data on disk - 8KB heap pages, item pointers, tuple headers, TOAST, and the free space map.

PostgreSQL
Technical
PGInternals
11754

March 2026

10
PostgreSQL Internals · Part 1
March 28, 2026·8 min readPopular

PostgreSQL Internals - Module 1: Process & Memory Architecture

Learn how PostgreSQL manages backend processes, the postmaster, shared buffers, and memory contexts. A deep dive into PG's process and memory model.

PostgreSQL
Technical
PGInternals
2821215

Stay Updated

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

By subscribing, you agree to our Privacy Policy.

5 parts

Projects

1 part

Reading PostgreSQL

Walking through PostgreSQL concepts directly from the source code

2 parts