Re:Pg_bm25: Elastic-Quality Full Text Search Inside Postgres
by machty on Wednesday October 11, 2023 @07:18PM
(#37851614)
What kind of "consistency" do bm25 indexes offer? e.g. I think ElasticSearch is eventually consistent and is constantly indexing in the background and classic Postgres GIN indexes have configuration like `gin_pending_list_limit` and `fastupdate` functionality to avoid slowdowns on insertions (and then you get slowdowns when an insert hits the threshold and triggers the catch-up indexing).
[ Parent
| on HN ]
Re:Pg_bm25: Elastic-Quality Full Text Search Inside Postgres
by philippemnoel on Thursday October 12, 2023 @06:42PM
(#37864089)
ParadeDB and pg_bm25 offer weak consistency. pg_bm25 doesn't slow down transactions for indexing, and like ElasticSearch it becomes become eventually consistent shortly after (typically at most a few seconds, altough your mileage may vary based on the amount of data modified in the transaction(s)).