Oh interesting… I have the entire SEC database to index (only indexing the text in a sliver of it at the moment) and use tsvector and I could use something faster.
replyunrelated! full-text search vs vector search, and this has a more permissive license.
replyAh, 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