September 21, 2026•1 min read
Postgres under list pressure: partial indexes that skip cold rows
App lists almost always filter on status or soft-delete. A partial index keeps only hot rows: smaller, cheaper to maintain. EXPLAIN tells you if the planner can use it.
Postgres
Read more