pgvector's HNSW index has a memory cliff, and the Postgres defaults walk right into it
pgvector handles most RAG workloads under ten million vectors just fine. The HNSW index underneath it has a memory requirement Postgres won't mention until the build already ran 40x slower.
By FlowVerify Editorial Team