pgvector: HNSW vs IVFFlat Index — A Practical Comparison

Observation

HNSW gives better query speed in most read-heavy retrieval systems, but write behavior and rebuild expectations matter more than benchmark charts suggest.

Practical note

Choose the index that matches your update pattern, not the one with the prettiest single-query number.