Optimization Treadmill

Five indexes turn one Postgres insert into six physical writes

A TigerData guide measures what one composite index saves a dashboard query, down to the buffer, then argues that indexes get added during incidents and nobody goes back to price what each one charges every insert.