Feb 5 · 4 min read · Operating a system like ChatGPT means handling millions of concurrent requests across regions, often with unpredictable traffic spikes. At this scale, database connection management becomes a first-order reliability concern. Even a well-provisioned d...
Join discussion
Aug 16, 2025 · 8 min read · inchirags@gmail.com Chirag's PostgreSQL DBA Tutorial https://www.chirags.in ************************************************************************************* Using PgBouncer to improve performance and reduce the load on PostgreSQL ***************...
Join discussion
Jun 29, 2025 · 5 min read · https://www.nilebits.com/blog/2025/06/postgresql-high-connections/ PostgreSQL is a powerful, open-source relational database system known for its reliability, extensibility, and advanced SQL compliance. But when your application scales and thousands ...
Join discussion
Jun 8, 2025 · 6 min read · This critique of Transaction Pooling in PgBouncer targets multi-tenant PostgreSQL setups that rely on session-level state (e.g., schema-per-tenant using search_path). Because Transaction Pooling discards session state after each transaction, it cause...
Join discussion
Oct 23, 2022 · 5 min read · We have an ag tech service running on GCP and we have a microservice that we do maintain consisting of Cloud SQL, Cloud Run, Cloud Functions. When we are developing and scaling our services, from the beginning we have been facing issues with Cloud SQ...
CChris commented