ParadeDB pg_search 0.26 cuts 10-term BM25 search from 129ms to 29ms
ParadeDB released pg_search 0.26.0 for Postgres, moving BM25 fieldnorms from a shared array into each term's postings list. A 10-term OR query dropped 4.3x (129ms to 29ms), while a single-term query got about 5x slower (1.34ms to 7.7ms).
- 10 OR-terms: 129ms on 0.25.11 vs 29ms on 0.26.0
- Single term: 1.34ms vs 7.7ms — about 5x slower
- Crossover between 2 and 4 terms, 0.26.0 wins beyond that
- Index grew only 216 KiB (0.2%) on a 96MB index
Read next
Software