Q7 PostgreSQL Domain 2 · 25–30% of exam Priority · Real Exam

A hybrid search must combine keyword relevance and vector similarity. Which PostgreSQL combination supports this natively?

  1. A tsvector full-text search with a GIN index, plus pgvector similarity, merged by a scoring expression (correct answer)
  2. B pgvector alone
  3. C Two separate databases
  4. D JSONB containment only

Shortcut: PostgreSQL can run full-text ranking (ts_rank over a GIN-indexed tsvector) and vector distance in the same query, blending both signals, often via reciprocal rank fusion.