Composite keys and ORM assumptions

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.