Millions of QPS | Scaling Postgres 402
This title could be clearer and more informative.Try out Clickbait Shieldfor free (5 uses left this month).
A roundup episode covering how OpenAI scales PostgreSQL to support 800 million ChatGPT users using a single primary with 50 read replicas, discussing their strategies around query optimization, connection pooling with PgBouncer, workload isolation, cascading replication, and schema management. Also covers PG Dog (a sharding pooler) updates and its Protobuf-to-Rust optimization for 5x speed gains, ClickHouse's new OLTP Postgres offering via a partnership with Ubicloud, an introduction to PostgreSQL shared buffers internals, a discussion on MySQL's uncertain future and migration paths, and a tutorial on combining fuzzy search (pg_trgm) with semantic search (pgvector) in Postgres.