perf(postgres): replacing table-scanning worker polling with partial B-tree indexes ⚡
Adding a partial index filtered specifically on
WHERE status IN ('pending', 'retry') reduced our queue pickup query latency from 85ms to 0.4ms across a 20M row table. What's the highest-ROI database index tweak you've ever deployed?commit ce2eed0