Millions of QPS | Scaling Postgres 402

In this episode of Scaling Postgres, we discuss how OpenAI's ChatGPT handles millions of queries per second, an update on PgDog, Clickhouse offers OLTP hosted Postgres and partition table source of truth.

Content Discussed

• Scaling PostgreSQL to power 800 million ChatGPT users
• PgDog update
• Replacing Protobuf with Rust to go 5 times faster
• Fast, scalable, enterprise-grade Postgres natively integrated with ClickHouse
• Introduction to Buffers in PostgreSQL
• Is the future of MySQL PostgreSQL (Or MariaDB, or TiDB, or ...)?
• Finding ‘Abbey Road’ When Users Type ‘beatles abbey rd’ - Fuzzy and Semantic Search in PostgreSQL
• Why Your HA Architecture is a Lie (And That's Okay)
• How to render timestamp with a timezone that is different from current?
• PostgreSQL 18 Temporal Constraints
• Introduction to PostgreSQL Indexes
• 500 Milliseconds on Planning: How PostgreSQL Statistics Slowed Down a Query 20 Times Over
• CSI: Postgres — Did someone change my table??
• What's New in the pgEdge Postgres MCP Server: Beta 2 and Beta 3
• Commercial PostgreSQL distributions with TDE (1) Fujitsu Enterprise Postgres (1) Setup
• Phenomenology through PostgreSQL Documentation
• PostgreSQL Anonymizer, available in all good shops
• PGXN Tools v1.7
• Unused Indexes In PostgreSQL: Risks, Detection, And Safe Removal
• Unlocking High-Performance PostgreSQL: Key Memory Optimizations
• Migrating Sybase ASE aka SAP ASE to PostgreSQL
• CERN PGDay: an annual PostgreSQL event in Geneva, Switzerland
• TimescaleDB for Manufacturing IoT: Optimizing for High-Volume Production Data
• Supabase PrivateLink is now available
• Managing IP address exhaustion for Amazon RDS Proxy

YouTube Video

Podcast Audio