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
June 5, 2026·9 min readPopular

Building a Local PostgreSQL Internals Assistant - Zero API Costs

Local PostgreSQL internals assistant - semantic search over PG source via pgvector + Ollama, exposed as MCP tools in Zed and VSCode. Free, offline, zero API costs.

Technical
Artificial Intelligence
LLM
977🔥2👏2

May 2026

pg_ext_memcheck - The memory bug detector that speaks PostgreSQL
Projects
May 29, 2026·7 min read

pg_ext_memcheck - The memory bug detector that speaks PostgreSQL

A PostgreSQL extension that catches MemoryContext leaks, wrong-context allocations, and shmem overruns — from inside the backend.

Technical
Project
162
pg_ext_memcheck - The memory bug detector that speaks PostgreSQL
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
Rust Basics - Module 5: Generics and Traits
Rust Basics
May 19, 2026·9 min read

Rust Basics - Module 5: Generics and Traits

Learn Rust traits, generics, trait bounds, and static vs dynamic dispatch. Understand how Rust achieves polymorphism without runtime cost using monomorphisation.

Technical
Rust
102
Rust Basics - Module 5: Generics and Traits
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
Rust Basics - Module 4: Structs, Enums and Pattern Matching
Rust Basics
May 10, 2026·9 min read

Rust Basics - Module 4: Structs, Enums and Pattern Matching

Learn Rust structs, enums, Option<T>, and pattern matching. Understand algebraic data types and how match eliminates null pointer bugs at compile time.

Technical
Rust
71
Rust Basics - Module 4: Structs, Enums and Pattern Matching

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