OpenAI scales PostgreSQL for 800 million users with a single writer (no sharding)
Every time an article comes out about a large company’s infrastructure, half the Hacker News comments are variations of “of course they use Kubernetes with 47 microservices and a distributed database with custom consensus protocol.” And when it turns out they don’t—that they use plain PostgreSQL with a single primary and discipline—there’s an uncomfortable silence. That just happened with OpenAI. The numbers nobody expected Bohan Zhang, infrastructure engineer at OpenAI, published details about how they scale PostgreSQL for ChatGPT. The numbers: ...