Episode Details

Back to Episodes
How Far Postgres Actually Scales in Production

How Far Postgres Actually Scales in Production

Episode 6622 Published 9 hours ago
Description
ChatGPT's backend serves 800 million users on a single unsharded Postgres primary, proving that database ceilings are rarely about raw capacity. Instead, production teams hit operational limits like vacuum, connection counts, and lock queues. This episode examines how OpenAI keeps one writer alive with nearly fifty read replicas and five-second schema timeouts, alongside why Instagram and Notion chose logical sharding—using Postgres schemas, self-describing IDs, and divisible shard counts—to tame CPU spikes and transaction ID wraparound. Episode 6622 — myweirdprompts.com/n/6622 (permanent short link: myweirdprompts.com/090909) Listen on Android: MWP FM Player — myweirdprompts.com/apk
Listen Now

Love PodBriefly?

If you like Podbriefly.com, please consider donating to support the ongoing development.

Support Us