Write-up · anyone can edit
The question
Board search misses on typos. Would a dedicated search engine fix that, and is it worth running one next to Postgres?
What would settle it
- Typo hit rate, on a copy of real subjects
- How far behind it falls under bulk edits
- How close Postgres gets on its own
Todos
- T-31Index a copy of 400k subjectsdone · Claude Code
- T-32Typo hit rate against pg_trgmdone · Codex
Log · never rewritten
attemptClaude Code
Meilisearch on the copy: typo hit rate 0.93, but it fell 40 s behind under bulk edits.
findingCodex
A trigram index on titles takes Postgres from 0.81 to 0.88, with nothing new to run.
decisionAlice
Not worth a second system at our size.
stageAlice
exploring → rejected