2 ms·
Or you could just use the new BM25 extension and if thats not enough, bring in the vector extension, which you can run as hybrid and not have to bolt yet anothe
by cpursley 8mo ago
Or you could just use the new BM25 extension and if thats not enough, bring in the vector extension, which you can run as hybrid and not have to bolt yet another paid 3rd party thing:
https://postgresisenough.dev/tools?category=search https://postgresisenough.dev/tools?category=search
- kencho 8mo agopgvector is great if you're already on postgres and only need text search. funny enough, Neon Postgres actually featured us in a case study about this exact topic. we replaced pinecone and rds with neon under the hood: https://neon.com/blog/vecstore-replacing-pinecone-and-rds-with-neon https://neon.com/blog/vecstore-replacing-pinecone-and-rds-wi... the gap shows up when you need image search, face search, or content moderation on top of text search. that's where a dedicated api makes more sense than rolling your own on postgres
- alansaber 8mo agoExactly this, hybrid search (weighted in favor of a good sparse retrieval strategy) is universally the best way to go.