B-Tree

Posts tagged “B-Tree”.

B-TreeClear filters
PostgreSQL B-Tree Index Explained: How It Really Works

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

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

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