pgvector vs numpy on 100k vectors: exact scan is 5x slower, HNSW is 7x faster
On 100k x 384 vectors, numpy exact search took 7.2 ms, pgvector without an index 37 ms, and pgvector HNSW 1.0 ms at 0.955 recall@10. Measured on 2 vCPUs.
Metadata filtering in vector search: post-filter loses results, measured
At 1% selectivity, post-filtering top-100 from HNSW recalled 19% of the true results. In-graph filtering kept 100% but took 17 ms. Measured on 100k vectors.
Do you need a vector database? Brute-force search benchmarked from 10k to 1M vectors
Exact numpy search over 100k embeddings takes 3.5 ms on 2 vCPUs. Measured latency, memory and HNSW recall to show when an index actually pays off.