The metrics behind nearest-neighbour retrieval and why ANN indexes make it fast.
01
01
Understand the problem
similaritycosineannhnsw
02
02
Attempt it yourself
Sketch your approach before reading the solution — that's what interviews test.
Stuck? AI Nudge Available
Get a conceptual hint to guide your logic without spoiling the final implementation.
03
03
Study the solution
The solution is waiting
Give it an honest attempt first — then compare your thinking with the full walkthrough.
04
04
Read the code
pgvector: metric operators and an HNSW index
-- cosine distance operator: <=> (dot: <#>, euclidean: <->)
CREATE INDEX ON chunks USING hnsw (embedding vector_cosine_ops);
SELECT id, title, 1 - (embedding <=> $1) AS similarity
FROM chunks
WHERE tenant_id = $2 -- filter + ANN together
ORDER BY embedding <=> $1
LIMIT 10;05
05
Join the discussion
Discussion (0)
Sign in to join the discussion.
No responses yet. Be the first to share what you think.