#internals
5 posts
How things actually work under the hood — pages, plans, runtimes, and the layers most code never touches.
-
Postgres Concurrency Internals: Connections, Locks, and MVCC
A practical guide to how Postgres handles many concurrent clients — process-per-connection, pooling, lock manager, MVCC tuples, deadlocks, and pg_locks.
postgresqldatabaseconcurrencyinternalsperformance -
Postgres Partitioning: Strategies, Real Advantages, and Pitfalls
A practical guide to PostgreSQL partitioning — RANGE, LIST, HASH, pruning, local indexes, real advantages, and the pitfalls that bite in production.
postgresqldatabaseperformanceinternals -
B-Trees and B+ Trees: From Binary Trees to Database Indexes
If you know binary search trees, you are halfway to understanding how databases find your data. B-trees are BSTs that got wide on purpose — here is why.
databasedata-structuresinternals -
PostgreSQL Indexing: Internals, Types, and Trade-offs
A practical guide to PostgreSQL indexes: B-tree, GIN, GiST, BRIN, hash — when to use each, composite key ordering, and CONCURRENTLY pitfalls.
postgresqldatabaseperformanceinternals -
How Databases Actually Store and Find Your Data
A bottom-up look at how databases physically store data — pages, heaps, B-trees, clustered indexes, and row IDs.
databaseinternalsperformance