Where indexing stops working

Partition pruning is paid for in your primary key definition

A nationwide logistics platform's tracking events table crossed a billion rows and new indexes stopped helping. The write-up that followed spends most of its warnings on constraints and the planner, not on latency.