Chapter DVector DB integration labPage 4 of 8

Vector DB integration lab

Measure recall@5 on the golden support questions

Page 4 advances one concrete versioned pgvector support-runbook index: explain the decision, run the code, inspect failure, measure evidence, and keep only what is ready to ship.

~15 minEvaluation

Before you start

Why this matters

Predict the metric value for a tiny golden set if one labeled case is deliberately mismatched. How could an aggregate still look “good enough” while the versioned pgvector support-runbook index is unsafe to ship?

1Learn the idea

Read

Build focus

A plausible result is not yet evidence. Evaluate with recall@5 ≥ 0.90, zero cross-tenant hits, and p95 query latency under 150 ms. The test fixture should contain an easy positive case, an easy negative or baseline case, and the boundary case most likely to flip. Separate assertions about software contracts from claims about model quality.

Recall@5 asks whether the expected evidence appeared in the first five results, not whether the LLM wrote a pretty paragraph. Label twenty questions with expected chunk IDs, including paraphrases. Store per-case hit/miss so one easy cluster cannot hide systematic misses.

The artifact's user-facing goal is specific: return five tenant-scoped chunks for a support question without changing the answer API. Its accepted input is chunk IDs, tenant_id, body text, embedding model id, and index_version. Those statements are intentionally narrower than “build an AI system.” Narrow scope lets us inspect every input and expected result, and it prevents a toy result from being presented as a production claim. System shape for this chapter: an ingestion worker chunks documents, an embedding adapter creates fixed-size vectors, PostgreSQL with pgvector stores vectors plus tenant metadata, and a query service embeds one question, applies an authorization filter, and returns five chunks to the answer layer. Keep model calls behind adapters, keep authorization and validation in deterministic code, and carry stable IDs and versions through every response. That separation lets you decide whether a bad result came from input handling, retrieval, inference, validation, or deployment. This page's job is the evaluation step: a plausible result is not yet evidence. Setup baseline for the chapter (run once per machine, not secrets in git):

docker run --name rag-pg -e POSTGRES_PASSWORD=rag -p 5432:5432 -d pgvector/pgvector:pg16
python -m venv .venv && source .venv/bin/activate
pip install psycopg[binary] pgvector sentence-transformers

If hardware or a hosted provider differs, preserve the interface and expected behavior. Do not present provider syntax as universal—when a vendor adapter is unavoidable, keep it behind a thin boundary and test with a fake first. The deliverable is not “it ran once”; it is a reproducible artifact another developer can inspect, including expected output and one deliberate failure related to dimension mismatch or cross-tenant retrieval. Operationally, write down the owner of this stage, the command you ran, the observed output, and the next page's dependency on that output. If you cannot point to a file, fixture, metric, or config key, the stage is not done. Prefer small, reviewable increments: one contract, one path, one metric, one failure, one gate. When tradeoffs appear—latency versus quality, hit rate versus false hits, local privacy versus cloud quality—record both numbers instead of moving the threshold until the report looks green. The chapter ships only when evidence for recall@5 ≥ 0.90, zero cross-tenant hits, and p95 query latency under 150 ms and a rehearsed recovery path exist beside pgvector index mini-v1/mini-v2 with HNSW after bulk load and env-based version switch.

Read

Run the example

Save this as lesson.py and run python3 lesson.py. Prefer the standard library or the pinned packages from the setup block so the example stays reproducible.

gold=[("What does ERR-502 mean?","runbook-7"),("How do I reset MFA?","runbook-3")]
index={"runbook-7":"ERR-502 upstream timeout","runbook-3":"MFA reset requires admin approval"}
def top1(q): return max(index, key=lambda k: len(set(q.lower().split()) & set(index[k].lower().split())))
hits=sum(top1(q)==want for q,want in gold)
print("recall_at_1", hits/len(gold))

Expected output: recall_at_1 1.0. Exact floating-point formatting may vary slightly, but the asserted behavior must not. Read the output as evidence about this stage, not merely proof that the interpreter started.

Read

Debug the stage

Print per-case expected versus observed values. Aggregates that look green can still hide a severe slice failure. At the evaluation stage, save the smallest failing fixture beside the expected result. Change one cause at a time and rerun the exact command printed above; that makes the repair reviewable and keeps this chapter's progressive artifact reproducible.

Read

Evaluate before continuing

Require the stated thresholds for recall@5 ≥ 0.90, zero cross-tenant hits, and p95 query latency under 150 ms. Do not delete hard cases to green the report. For this evaluation page, preserve the fixture and result as evidence for the next page. Label observations separately from conclusions: a passing assertion establishes the behavior it names, while broader usefulness requires the chapter's full evaluation set and stated operating limits. Primary metrics for the chapter remain recall@5 ≥ 0.90, zero cross-tenant hits, and p95 query latency under 150 ms.

Checking tutor…

Continue learning · glossary & guides
  • [ ] Does the fixed set include positive, negative, and boundary cases?
  • [ ] Are contract tests separated from quality metrics?
  • [ ] Did I compare against a simple baseline?
  • [ ] Do I understand recall@5 ≥ 0.90, zero cross-tenant hits, and p95 query latency under 150 ms?

Glossary: vector database · Glossary: vector index · Cheatsheet: RAG quality

Previous · Next