How OpenAI Scales Postgres to Power 800 Million ChatGPT Users
Engineering insights reveal read replicas and single primary architecture handling millions of queries per second.
OpenAI has shared insights into how PostgreSQL powers ChatGPT for 800 million users, handling millions of queries per second with a read replicas and single primary architecture.
Architecture Overview
OpenAI uses PostgreSQL as the database for ChatGPT, operating at incredible scale. Rather than sharding across multiple primary databases, OpenAI uses a single primary database with read replicas to handle query volume.
Scale Performance
The architecture handles millions of queries per second, supporting 800 million ChatGPT users. This demonstrates PostgreSQL's capability to operate at hyperscale without complex sharding strategies.
Database Strategy
Bohan Zhang from OpenAI shared that the single-primary approach with read replicas provides operational simplicity while maintaining performance. The strategy reduces the complexity typically associated with operating databases at this scale.
Related Articles
Redis 8.4 Brings Hybrid Search, Atomic Multi-Key Operations, and Auto-Repair AOF
Redis 8.4 is now generally available, delivering hybrid search that combines full-text and vector queries using Reciprocal Rank Fusion, new atomic string commands like MSETEX and DELEX, and automatic repair for corrupted append-only files. Lookahead prefetching and JSON memory optimizations round out a performance-focused release.
Deno 2.7 Stabilizes Temporal API and Ships Native Windows ARM Builds
Deno 2.7 has stabilized the TC39 Temporal API, bringing immutable, timezone-aware date and time objects to replace the legacy JavaScript Date API. The release also delivers official Windows ARM builds for Surface and Snapdragon devices, npm overrides support, and global install compilation for standalone executables.
Laravel 13 Ships with PHP Attributes, Passkeys, and Zero Breaking Changes
Taylor Otwell unveiled Laravel 13 at Laracon EU, delivering PHP 8 Attributes as an alternative to class properties, built-in passkey authentication in starter kits, and a new Reverb database driver for horizontal WebSocket scaling. The release requires PHP 8.3+ and promises the smoothest upgrade path in Laravel history.