HNSW vs IVFFlat: Choosing and Tuning Your pgvector Index
In pgvector you choose an index type, and the two real options are HNSW and IVFFlat. With no index, queries do exact search on every row: accurate but slow at scale. Here is the trade-off between the two approximate indexes and how to tune each one.
