Three bugs that made our time-series queries 680 slower (and how we found them)
This story is from 2026-10-07. It is preserved in the archive; the latest stories are on the live feed.
A SELECT ... ORDER BY ts DESC LIMIT 10 on a 1M-row table took 1.2 seconds . It should have taken single-digit milliseconds. The worst part? Our EXPLAIN said we were using the fast path. We were wrong. This is the story of the three bugs behind that number, how differential testing caught them, and…
Read the full story at DEV Community — AI ↗
Timeline · 1 report
- 2026-10-07 08:09 · DEV Community — AI
Three bugs that made our time-series queries 680 slower (and how we found them)