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.