pgvector

The reference for vector similarity search in Postgres: types, operators, HNSW and IVFFlat indexes, filtering.

An HNSW index only serves ORDER BY distance LIMIT on the table itself. Wrapping it in DISTINCT ON quietly turned it off for me.

Anyone running RAG on Postgres.