Level: Intermediate
I'll be presenting how Instacart redesigned its search infrastructure with PostgreSQL as the backbone for a hybrid search system. Moving away from a legacy Elasticsearch setup, the team adopted pgvector to unify vector and keyword search within Postgres, enabling significant improvements in system simplicity and developer agility. The presentation will highlight lessons learned in optimizing Postgres for real-time, large-scale retrieval as a case study for teams seeking to consolidate retrieval systems without compromising speed or relevance.
Reference : https://tech.instacart.com/how-instacart-built-a-modern-search-infrastructure-on-postgres-c528fa601d54