Hybrid Search Patterns with Postgres and pgvector

3 months ago by steam_lover to c/postgresql

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.
postgresql
postgresql

@programming.dev

login for more options
2251
203
21

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

go to feed...