BestHub
Sign in
Tagged articles
3 articles
Page 1 of 1
AI Engineering
AI Engineering
Jan 24, 2026 · Databases

Can One PostgreSQL Instance Power 800 Million Users? OpenAI’s Trade‑offs Unpacked

OpenAI runs a single primary PostgreSQL with about 50 replicas to serve roughly 800 million ChatGPT users, employing PgBouncer connection pooling, cache‑lock mechanisms, query and schema optimizations, workload isolation, multi‑layer throttling, and cascade replication, while acknowledging the architecture’s limits and the complexity of full sharding.

Azure CosmosDBCascade ReplicationOpenAI
0 likes · 8 min read
Can One PostgreSQL Instance Power 800 Million Users? OpenAI’s Trade‑offs Unpacked
dbaplus Community
dbaplus Community
Nov 2, 2025 · Databases

How a Simple PgBouncer Switch Saved Us $10 Million in Cloud Costs

When a sudden 38% rise in AWS bills revealed hidden connection‑storm costs in a Kubernetes‑based microservice architecture, the team introduced PgBouncer as a transaction‑pooling proxy, slashing database connections from over 14,000 to under 400 and cutting monthly cloud spend by more than $300,000, ultimately saving $10.8 million over three years.

Connection PoolingCost OptimizationKubernetes
0 likes · 9 min read
How a Simple PgBouncer Switch Saved Us $10 Million in Cloud Costs
IT Services Circle
IT Services Circle
Dec 5, 2024 · Databases

Understanding High-Concurrency Connection Issues in PostgreSQL and the Benefits of Using pgBouncer

The article explains how thousands of simultaneous client connections to a single PostgreSQL primary can cause severe write‑performance degradation, how introducing a connection pool such as pgBouncer reduces active backend processes dramatically, and why external pooling is preferred over built‑in solutions, illustrated with real‑world examples and a reference to the open‑source Pigsty distribution.

Connection PoolingDatabase ArchitecturePgBouncer
0 likes · 7 min read
Understanding High-Concurrency Connection Issues in PostgreSQL and the Benefits of Using pgBouncer