AI Tools
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.
May 18, 2026