How Database Indexes Work: B-Tree Pages, Query Plans, and the Write Cost
Learn how database indexes work in PostgreSQL, from B-tree internals and query plans to multicolumn, covering, and partial indexes. Explore ...
Oct 27, 2026
16 min
Learn how database indexes work in PostgreSQL, from B-tree internals and query plans to multicolumn, covering, and partial indexes. Explore ...