pgvectorSoftware
liked
Hybrid Search in Postgres with pgvector for semantic search: Our current solution which combines lexical and embedding-based retrieval in a single Postgres engine.
Instacart's hybrid search on Postgres with pgvector
tech.instacart.com ↗·2025-05-28Wrong?
PostgreSQLSoftware
liked
Postgres is tremendously powerful and we saw no reason to move away from it, especially with horizontally-scaling options like Aurora available.
Instacart on staying with Postgres while scaling its fulfillment data
tech.instacart.com ↗·2018-08-14Wrong?
PostgreSQLSoftware
recommended
In the case of Postgres, by pushing the availability information and other data sources into the database and using a normalized data model, we were able to consolidate all the network calls and avoided the need to overfetch and filter the results.
How Instacart moved search from Elasticsearch to Postgres
tech.instacart.com ↗·2025-05-28Wrong?
FAISSSoftware
uses
introducing semantic retrieval in FAISS boosted search quality
Instacart's first semantic retrieval ran on FAISS before moving to pgvector (undated page)
tech.instacart.com ↗Wrong?
ElasticsearchSoftware
disliked
In our case, our Elasticsearch implementation did not scale well due to our denormalized data model and the nature of our write workloads.
How Instacart moved search from Elasticsearch to Postgres
tech.instacart.com ↗·2025-05-28Wrong?