News for hackers. Stuff that matters.
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).
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)).