0votes
0answers
0joined
Semantic search over 10M chunks is slow; HNSW index bloat is the suspect
pgvector HNSW index on a 10M-row chunk table takes 800ms p95 for top-10 nearest-neighbor search. Index size is 14GB (larger than the data). Rebuilding with ef_construction=64 and M=16 didn't help. Queries should be ~50ms at this scale.