Скачать или смотреть Postgres vs. Elasticsearch: Instacart’s Unexpected Winner in High-Stakes Search with Ankit Mittal

In this episode of The Data Engineering Show, host Benjamin Wagner speaks with Ankit Mittal, former senior engineer at Instacart, about the company's innovative approach to modernizing their search infrastructure by transitioning from Elasticsearch to PostgreSQL for single-retailer search functionality.

Episode Chapters:

[00:00] Intro: Modernizing Search at Instacart
[02:27] Understanding Search Types and Retrieval Systems
[04:05] From Elasticsearch to PostgreSQL: The Migration Journey
[09:23] Real-Time Search Flow and Query Processing
[13:12] Custom PostgreSQL Architecture and Extensions
[15:04] Data Ingestion Pipeline and Table Maintenance
[19:06] Trade-offs and Challenges in Production
[21:06] Final Thoughts: The Future of Search Infrastructure

If you enjoyed this episode, make sure to subscribe, rate, and review it on Apple Podcasts, Spotify, and YouTube Podcasts. Instructions on how to do this are here: https://www.fame.so/follow-rate-review

Episode Resources:

Instacart - Grocery delivery platform
ParadeDB - Database technology company
Firebolt - Cloud data warehouse: https://www.firebolt.io/

Articles:
Instacart Search Modernization Blog Posts (Series on hybrid retrieval)
Target's AlloyDB Migration Blog Post

FOR FEEDBACK & DISCUSSIONS ON FIREBOLT CORE:

Join Firebolt Discord Community:   / discord  
Join Firebolt Github Discussions: https://github.com/firebolt-db/firebo...
Firebolt Core Github Repository: https://github.com/firebolt-db/firebo...
Benjamin's Email: [email protected]