Skip to content
Samba.dev
AboutProjectsBlogNowContact
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.

31 articles
1.7k reads
14 tags
All
Artificial Intelligence (2)
Personal (10)
PostgreSQL (13)
Productivity (1)
Technical (20)
Thoughts (1)
Clear filter

Series

PostgreSQL Internals

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

+19 parts

Monthly Books Summary

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

August 2026

Vacuum - PostgreSQL way of clearing it's Debt
Reading PostgreSQL
August 8, 2026·10 min readNew

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.

PostgreSQL
Technical
PGSourceCode
581
Vacuum - PostgreSQL way of clearing it's Debt

July 2026

PostgreSQL Internals - Module 9: Replication
PostgreSQL Internals
July 17, 2026·12 min read

PostgreSQL Internals - Module 9: Replication

Final blog post of the PostgreSQL Internals series explaining about Replication and it's type i.e., Physical and Logical Replication.

PostgreSQL
Technical
PGInternals
181🔥1
PostgreSQL Internals - Module 9: Replication

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
Technical
PGSourceCode
733
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.

PostgreSQL
Technical
PGSourceCode
853🔥2🧠1👏1
TableAmRoutine - your way of integrating a custom storage engine into PostgreSQL

May 2026

PostgreSQL Internals - Module 8: Concurrency & Locking
PostgreSQL Internals
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
461
PostgreSQL Internals - Module 8: Concurrency & Locking
PostgreSQL Internals - Module 7: VACUUM, Autovacuum & Bloat
PostgreSQL Internals
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
362💡1
PostgreSQL Internals - Module 7: VACUUM, Autovacuum & Bloat
PostgreSQL Internals - Module 6: Indexing Internals
PostgreSQL Internals
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
483🔥1👏1
PostgreSQL Internals - Module 6: Indexing Internals

April 2026

PostgreSQL Internals - Module 5: Query pipeline
PostgreSQL Internals
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
767🔥1👏1
PostgreSQL Internals - Module 5: Query pipeline
PostgreSQL Internals - Module 4: Write-Ahead Logging, Checkpoints and Crash Recovery
PostgreSQL Internals
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
874🔥2
PostgreSQL Internals - Module 4: Write-Ahead Logging, Checkpoints and Crash Recovery
PostgreSQL Internals - Module 3: MVCC & Transaction Isolation Levels
PostgreSQL Internals
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
777👏1
PostgreSQL Internals - Module 3: MVCC & Transaction Isolation Levels

Stay Updated

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

By subscribing, you agree to our Privacy Policy.

5 parts

Book Review

A few reviews on Books I really loved

1 part

Rust Basics

A series to learn the Rust Basics

5 parts

Projects

1 part

Reading PostgreSQL

Walking through PostgreSQL concepts directly from the source code

3 parts