--- title: "Millions of QPS | Scaling Postgres 402" url: https://daily.dev/posts/millions-of-qps-scaling-postgres-402-ep7pqrcsn source_url: https://www.youtube.com/watch?v=NHOdbhpPMaI type: video:youtube source: "Scaling Postgres" published: 2026-05-31T07:44:26.938Z updated: 2026-05-31T07:57:04.884Z tags: ["backend", "postgresql", "pgvector"] reading_time: 18 upvotes: 0 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Millions of QPS | Scaling Postgres 402 **[Scaling Postgres](https://daily.dev/sources/scaling-postgres)** · 18 min read · 0 upvotes · 0 comments ## Summary 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. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Scaling PostgreSQL to power 800 million ChatGPT users](https://daily.dev/posts/scaling-postgresql-to-power-800-million-chatgpt-users-3mbfuagbd) · OpenAI · 297 upvotes · 11 comments - [How OpenAI Scaled to 800 Million Users With Postgres](https://daily.dev/posts/how-openai-scaled-to-800-million-users-with-postgres-0qbtpoqpy) · ByteByteGo · 329 upvotes · 2 comments - [OpenAI Scales Single Primary Postgresql to Millions of Queries per Second for ChatGPT](https://daily.dev/posts/openai-scales-single-primary-postgresql-to-millions-of-queries-per-second-for-chatgpt-wcyldtady) · InfoQ · 31 upvotes · 0 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#postgresql](https://daily.dev/tags/postgresql), [#pgvector](https://daily.dev/tags/pgvector) [View this post on daily.dev](https://daily.dev/posts/millions-of-qps-scaling-postgres-402-ep7pqrcsn)