A regional e-commerce marketplace
Rebuilt search from SQL LIKE queries to a proper full-text index.
ফলাফল
Search p95 latency
45ms
↓ from 3.2s
Zero-result searches
−31%
vs. previous quarter
চ্যালেঞ্জ
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.
সমাধান পদ্ধতি
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.
ফলাফল
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.
ব্যবহৃত টেক স্ট্যাক
“The security review came back clean, which is a very short conversation to have with investors.”
CTO
CTO, a healthcare scheduling startup
আপনার বিজনেসেও এমন সমাধান চান?
আমাদের জানান কী ধরনের সিস্টেম আপনার প্রয়োজন।