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.

Write it as you would say it in the interview: assumptions, the design, tradeoffs, and what you would do next. The draft saves in this browser.

Review the lesson