Support for pg_bm25

For retrieval tasks in our RAG pipeline or even just generic search, it is useful to do re-rank with full-text. We are currently using pg_trgm, but trigram matching is not sufficient. The performance is not viable for re-ranking. To that end, we are hoping to get support for pg_bm25 if at all possible.

I was going to ask about pgroonga as well, but it seems like that thread was already closed.

Hey @skeptrune,

I’ll share your request with the team about adding support for pg_bm25 :smile:


Hey, have you heard anything back from them as of yet?

Hey @skeptrune, apologies for the delayed response. Unfortunately, this extension is not compatible with our storage system, so we won’t be able to support it