Schedule - PGConf NYC 2023

Postgres as Personalization Engine

Date: 2023-10-03
Time: 11:00–11:50
Room: The Forum
Level: Intermediate
Feedback: Leave feedback

We at Instacart have been running a large scale recommender engine in Postgres. We send trained models metadata and features data to Postgres and do inference inside PG. This cluster being a Postgres cluster works with a workload that is a combination of multiple table joins, full text search and personalized ranking via embeddings. The cluster is self hosted, replicas receive WAL shipped by pgbackrest. The applications can survive primary loss by serving stale data and replica loss by banning individual nodes.

Slides

The following slides have been made available for this session:

Speaker

Ankit Mittal
Jonathan Phillips