Ah, I remember now that ParadeDB's pitch was doing hybrid search by using pgvector with keyword rankings from pg_search. Never got the chance to try it.
replySometimes you want both. I wonder if there is a postgresql reranker…
reply(Tiger data employee fwiw)
replyWe have an alternative full-text search extension as well, pg_textsearch that's completely open source that supports hybrid re-ranking
Here's a blog on it (i linked to the section on hybrid search, there's a code snippet for you in there)
https://www.tigerdata.com/blog/introducing-pg_textsearch-tru...
We're big fans of extending Postgres for more and more usecases
deleted
reply