Tag: sql

The day I sped up a slow Postgres query by 40x

Tracing high buffer reads in EXPLAIN ANALYZE and replacing a misordered index with a partial composite index to cut latency from 480ms to 11ms.

• postgresql
• sql
• performance