DevLift

Blog

Tutorials, guides, and insights to help you become a better developer.

Clear
How Database Indexes Work: B-Trees, Buffers, and the 46% Rule
A measured tour of B-tree indexes on PostgreSQL 17, with real query plans for index-only scans, the visibility map, HOT updates, and the selectivity point where the planner abandons your index.
AdminAugust 7, 202610 min read

Stay in the Loop

Get notified about new courses, tutorials, and learning tips. No spam, unsubscribe anytime.