ParadeDB pg_search 0.26 speeds multi-term queries but slows single-term searches
ParadeDB released version 0.26.0 of its pg_search PostgreSQL extension on October 3. The update rewrites how the extension stores field-length data needed for BM25 relevance scoring. Benchmarking showed a query combining ten search terms became over four times faster, dropping from approximately 129ms to 29ms. However, the same update made single-term queries roughly five times slower, increasing from about 1.5ms to over 8ms. The performance changes are attributed to a redesign that consolidates internal queries and moves field-norm data.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in