Hybrid Search Patterns with Postgres and

programming

g/programming

2mo

ago

public

earned

reactions

#programming

#technology

#dev

Hybrid Search Patterns with Postgres and pgvector

Yesterday, pgvector released 0.8.6!

So today, we wrote about some useful patterns for queries combining pgvector indexes with regular 'ole scaler filters. Spoiler: iterative index scans launched in pgvector 0.8 make it easy (with some tradeoffs).
#programming #technology #dev

Hybrid Search Patterns with Postgres and pgvector | Crunchy Data Blog

Filtered vector search in Postgres forces a tradeoff between recall and speed because ANN indexes and WHERE clauses do not intersect like B-trees. Read about pgvector iterative scans, partial HNSW indexes, oversampling with pg_stats, caching, and more.

	earnings
	3,000 mlx total
	$0 total

	engagement
	4 views
	0 reactions

Hybrid Search Patterns with Postgres and pgvector…

0 comments