Can you please add this shameless plug?
https://github.com/jankovicsandras/plpgsql_bm25
Opensource BM25 search in PL/pgSQL (for example where you can't use Rust extensions), and hybrid search with pgvector and Reciprocal Rank Fusion.
https://github.com/jankovicsandras/plpgsql_bm25
Opensource BM25 search in PL/pgSQL (for example where you can't use Rust extensions), and hybrid search with pgvector and Reciprocal Rank Fusion.
We discussed this very thing on supabase
https://github.com/orgs/supabase/discussions/18061#discussio...