Scaling PostgreSQL at OpenAI: Read-Heavy Workloads and Optimizations - PGConf.dev 2025

13/08/2025 21 min

Listen "Scaling PostgreSQL at OpenAI: Read-Heavy Workloads and Optimizations - PGConf.dev 2025"

Episode Synopsis

A video transcript is used to review the PostgreSQL Development Conference (PGConf.dev 2025) presentation titled "Scaling Postgres to the Next Level at OpenAI." The speaker, Bhan from OpenAI, outlines their extensive experience scaling PostgreSQL to support critical, read-heavy workloads without traditional sharding, achieving millions of queries per second. He discusses optimizations implemented, such as reducing primary database load, improving query efficiency, and mitigating single points of failure. The talk also addresses past outages at OpenAI related to PostgreSQL, lessons learned, and areas where PostgreSQL could improve, like observability and schema change management.Source: https://youtu.be/Ni1SGhNu-Q4?si=CoHnwn7ccArykBAY

More episodes of the podcast AI: post transformers