Instacart rebuilt its entire search infrastructure on Postgres to handle billions of grocery items and real-time inventory changes, replacing Elasticsearch and FAISS with a unified hybrid retrieval system. By leveraging pgvector for semantic search alongside traditional text matching, they achieved 6% fewer dead-end searches while simplifying operations. This technical deep dive reveals how normalized data models and NVMe storage helped them conquer scale challenges.