How OpenAI Scaled PostgreSQL to 800M Users, and What to Do in Your System
OpenAI kept one PostgreSQL primary alive for a massive read-heavy workload by moving reads to replicas, pooling connections, protecting caches, rate limiting spikes, and pushing write-heavy workloads elsewhere. The useful lesson is not "Postgres scales forever." It is knowing which pressure you are actually under.
A practical guide to the OpenAI PostgreSQL scaling story: what they did, why it worked, and what normal engineering teams can do with batching, Kafka, idempotent writes, read replicas, caches, and workload isolation.