Blog / indexing

Posts tagged indexing

1 post filed under this topic.

• The Index Is Not a Magic Wand — Adding an index can make a query slower. A deep dive into PostgreSQL storage, B-tree internals, planner costs, composite indexes, write amplification, and the operational habits that keep an index set honest. 2026-10-24 · 18 min read