#Vector Search

pgvector Hybrid Search vs. Pure Vector: The Query Patterns That Flip the Winner

Pure cosine similarity returns garbage on version numbers, SKUs, and exact phrases. The fix is hybrid search in Postgres — two indexes, one CTE, and a rule for which leg to weight.