A regional e-commerce marketplace
Rebuilt search from SQL LIKE queries to a proper full-text index.
Result
Search p95 latency
45ms
↓ from 3.2s
Zero-result searches
−31%
vs. previous quarter
Challenge
Product search ran on `LIKE '%term%'` queries against a 200k-row table with no index — searches routinely took over 3 seconds and returned poorly ranked results.
Approach
Migrated search to Postgres full-text search with GIN indexes and weighted ranking across title, category, and description fields, with typo tolerance via trigram similarity.
Outcome
Search queries that used to scan the full table now hit an index, and relevance ranking meant fewer customers scrolled past page one without finding what they wanted.
Stack
“The security review came back clean, which is a very short conversation to have with investors.”
CTO
CTO, a healthcare scheduling startup
Want a similar outcome?
Tell us what's breaking under load, and we'll tell you what it would take to fix it.