The Query Wasn't Slow. The Storage Was.
Keyword search on 170,000 news articles took up to 36 seconds. EXPLAIN ANALYZE pointed at the wrong thing. The fix was a narrow table, and search now answers in 29 ms.
Keyword search on 170,000 news articles took up to 36 seconds. EXPLAIN ANALYZE pointed at the wrong thing. The fix was a narrow table, and search now answers in 29 ms.