Postgres Indexes Under the Hood: B-Trees, Page Splits, and Why the Query Planner Ignores You

An under-the-hood breakdown of 8KB index pages, Lehman-Yao B-link concurrency, page split WAL amplification, the visibility map trap, and why the Postgres planner chooses Seq Scan.