Search & Indexing
Product full-text
Users search product titles and descriptions with relevance ranking across millions of SKUs. OLTP is Postgres. Design the search index role, document fields, and why SQL alone is insufficient.
Intermediate drill question.