fromInfoQ
2 weeks agoInstacart Consolidates Search Infrastructure on Postgresql, Phasing Out Elasticsearch
A key part of the redesign was improving how results are retrieved. Traditional keyword search excels at matching exact product attributes, for example, a query like "pesto pasta sauce 8oz" benefits from precise lexical matching. But broader intent-driven queries, such as "healthy foods", are better handled through semantic retrieval, which understands relationships between terms and concepts. By combining both approaches in Postgres, Instacart can balance precision (returning only relevant results) with recall (capturing as many relevant items as possible), ensuring that customers see both the exact products they're looking for and meaningful options for discovery.
E-Commerce