PostgreSQL B-Tree Index Explained: How It Really Works
How the PostgreSQL B-tree index works: page structure, search and write behavior, and production maintenance with fillfactor, pgstattuple, amcheck, and REINDEX CONCURRENTLY.
September 11, 2026 · 9 min read
Mobin Yazdanparast
PostgreSQL Composite Indexes Best Practices
Master PostgreSQL composite indexes best practices: column order, leftmost prefix rule, INCLUDE, and when to prefer multicolumn over separate indexes for faster queries.
August 21, 2026 · 7 min read
Mobin Yazdanparast
How PostgreSQL Index Internals Actually Work
A deep dive into PostgreSQL index internals, exploring B-tree architecture, CTID heap mapping, MVCC visibility, and scan operations.
August 5, 2026 · 9 min read
Mobin Yazdanparast