PgBouncer Archives

Tech Optimizer

June 4, 2026

EDB adds quorum commit to distributed Postgres 6.4

EDB has released version 6.4 of its Postgres Distributed (PGD) solution, which includes enhancements such as quorum commit, native connection pooling, and support for PostgreSQL large objects. The quorum commit feature ensures a unified transaction outcome across cluster nodes before finalizing a transaction, addressing potential risks from conflicting writes in distributed systems. This update targets organizations in sectors like banking, payments, telecommunications, and infrastructure, aiming to provide the same consistency guarantees previously reliant on proprietary databases. The Connection Manager now includes native connection pooling, reducing the need for external connection poolers and streamlining operations by integrating with PGD's Raft consensus layer. This integration allows for automatic route adjustments during failover and improved monitoring capabilities. Additionally, the update expands replication support to include PostgreSQL large objects, enhancing the applicability of distributed Postgres for managing mixed data sets in sectors like government, healthcare, and financial services. EDB also noted a Gartner forecast that by 2030, over 75% of enterprises in Europe and the Middle East will have repatriated workloads to their home jurisdictions, emphasizing the importance of consistent data management across locations. EDB aims to strengthen Postgres's position in the market by focusing on transaction integrity in distributed environments while minimizing reliance on additional infrastructure components.

Tech Optimizer

May 28, 2026

EDB Releases PGD 6.4 with Quorum Commit, Bringing True Distributed Consistency to Mission-Critical Postgres

EnterpriseDB (EDB) has released EDB Postgres Distributed (PGD) 6.4, featuring three key enhancements: Quorum Commit for cross-node consistency, integrated connection pooling via the native Connection Manager, and full replication support for PostgreSQL large objects. Quorum Commit ensures that all nodes in a cluster reach consensus before committing transactions, addressing issues with traditional replication. The integrated Connection Manager simplifies operations by eliminating the need for external pooling solutions and providing cluster-aware routing and automatic failover. The support for large objects allows for the management of diverse data types within a single database environment. PGD 6.4 is available as a stand-alone distribution and will be integrated into EDB Postgres AI in June.

Winsage

May 15, 2026

For May, Patch Tuesday means 139 updates

Microsoft has released an extensive update for Azure Linux 3.0 and CBL Mariner 2.0, addressing 191 open-source Common Vulnerabilities and Exposures (CVEs) across various technologies, including the Linux kernel, Go runtime, Apache httpd, PHP, CoreDNS, Valkey, Ruby, GnuTLS, Apache Thrift, Node.js, Rust, Java implementations, Vim, Postfix, Expat, Nmap, Prometheus, KEDA, and PgBouncer. Additionally, Microsoft has fixed a critical vulnerability (CVE-2026-41103) in its Single Sign-On (SSO) Plugin for Jira and Confluence, which allows an attacker to forge a Microsoft Entra ID identity through a manipulated SAML response; however, patching this vulnerability is the responsibility of the users of Atlassian's platforms.

Tech Optimizer

February 19, 2026

How OpenAI Scaled to 800 Million Users on PostgreSQL

OpenAI has scaled PostgreSQL to support over 800 million active users of ChatGPT, making it one of the largest PostgreSQL deployments globally. The database can handle millions of concurrent connections and a very high volume of requests per second. OpenAI employs several strategies to optimize performance: 1. **Connection Pooling with PgBouncer**: Reduced database connections from 10,000 to 200, enhancing efficiency by a factor of 50. 2. **Read Replicas**: Distributes read requests across multiple replicas while the primary database handles writes. 3. **Horizontal Sharding**: Partitions data across multiple instances based on a shard key, such as user_id or tenant_id. 4. **Query Optimization**: Analyzes slow queries and creates appropriate indexes to maintain performance. 5. **Connection Management**: Implements timeouts and connection limits to prevent overload. 6. **Caching**: Uses application-level caching with Redis to reduce database load. 7. **Monitoring and Observability**: Tracks key metrics like connection counts and query latency to identify issues early. These strategies enable OpenAI to maintain performance and reliability for a large user base.

Tech Optimizer

February 12, 2026

OpenAI Scales Single Primary Postgresql to Millions of Queries per Second for ChatGPT

OpenAI scaled PostgreSQL to handle millions of queries per second for its ChatGPT service and API, serving 800 million users. Collaborating with Azure, they optimized deployment on Azure Database for PostgreSQL, maintaining a single-primary instance with nearly 50 geo-distributed read replicas to manage read operations and keep latency low. Key optimizations included increasing instance size, refining query patterns, and directing write-heavy workloads to sharded systems like Azure Cosmos DB. OpenAI faced operational challenges such as cache-miss storms and complex multi-table joins, which they addressed by shifting tasks to the application layer, enforcing stricter timeouts, and refining query structures. They reduced write pressure on PostgreSQL by migrating shardable workloads, implementing rate-limiting, and utilizing connection pooling with PgBouncer. Future strategies include exploring cascading replication to alleviate the primary instance's load and assessing sharded PostgreSQL deployments to enhance scalability while balancing consistency and performance.

Tech Optimizer

January 26, 2026

OpenAI Scales ChatGPT to 1M Queries/Second with PostgreSQL on Azure

OpenAI has optimized its database infrastructure using PostgreSQL to support 800 million monthly active users and process over a million queries per second without complex sharding. The architecture consists of a single primary instance with nearly 50 read replicas, achieving low double-digit millisecond response times at the 99th percentile. OpenAI employs best practices like connection pooling, query optimization, and strategic indexing, utilizing tools such as PgBouncer for efficient connection management. The company has achieved five-nines availability through failover mechanisms and has adapted to a tenfold increase in query volume within a year by tuning PostgreSQL parameters rather than creating custom solutions. OpenAI incorporates community-driven optimizations, such as custom indexing strategies and materialized views, and uses extensions like pgvector for managing vector data and embeddings. The organization continuously monitors for strain during traffic surges and adjusts by adding replicas or optimizing configurations. Their approach emphasizes simplicity, avoiding sharding to minimize operational overhead, and they plan to explore newer PostgreSQL features and AI-native capabilities in the future.

Tech Optimizer

October 8, 2025

How OpenAI scaled with Azure Database for PostgreSQL – Microsoft for Startups Blog

OpenAI utilizes PostgreSQL as the backbone for its essential systems, particularly in collaboration with Microsoft Azure Database for PostgreSQL. Initially, OpenAI adopted a straightforward architecture with a single primary Postgres instance for write operations and multiple read-only replicas for handling read traffic. This setup allowed for exceptional scalability in read operations, but as demand increased, write requests became a bottleneck. To address scalability challenges, OpenAI implemented several strategies, including offloading write workloads, optimizing read-heavy workloads with replicas and smart query routing, and establishing schema governance for stability. These optimizations led to significant outcomes: the PostgreSQL cluster now processes millions of queries per second, has numerous global read replicas for low-latency access, and has improved database response times from approximately 50 milliseconds to under five milliseconds for many queries. OpenAI's collaboration with Azure Database for PostgreSQL facilitated ease of scaling and replication, allowing for the seamless addition of replicas and the development of features like elastic clusters and cascading read replicas. The advantages of Azure included high availability, co-innovation support, and security compliance, providing a reliable foundation for OpenAI's optimizations.

Tech Optimizer

September 11, 2025

PgEdge Enterprise Postgres Now Fully Open Source And Scalable For Mission-Critical Workloads – Open Source For You

PgEdge has launched pgEdge Enterprise Postgres, a PostgreSQL distribution designed for enterprise needs, along with a transition of its distributed Postgres components to an open source licensing model. The distributed components, including Spock, Large Object Logical Replication (LOLOR), and Snowflake Sequences, are now licensed under the PostgreSQL License and available on GitHub. PgEdge Enterprise Postgres includes features such as high availability, support for PostgreSQL versions 16, 17, and 18, and enterprise-ready extensions like pgAudit and pgBackrest. Deployment options include native packages, containerization for Kubernetes and Docker, and managed services through PgEdge Cloud.

Tech Optimizer

September 11, 2025

pgEdge Unveils pgEdge Enterprise Postgres Alongside Full Commitment to Open Source

pgEdge has launched pgEdge Enterprise Postgres and transitioned all its Distributed Postgres components to an open source licensing framework under the standard PostgreSQL License. The new pgEdge Enterprise Postgres supports both distributed and non-distributed PostgreSQL applications and includes features such as high availability, support for PostgreSQL versions 16, 17, and soon 18, and enterprise-ready extensions. The product is available in VM Edition immediately and will have a Container Edition launching in Q4. It is compatible with various operating systems, with additional support services available.

Tech Optimizer

September 10, 2025

pgEdge Announces pgEdge Enterprise Postgres Alongside Full Commitment to Open Source

pgEdge has launched pgEdge Enterprise Postgres and transitioned to an open source licensing model for its distributed PostgreSQL components. The company is expanding its offerings to support both distributed and non-distributed applications based on standard PostgreSQL. Key features of pgEdge Enterprise Postgres include high availability for various workloads, support for PostgreSQL versions 16, 17, and 18, enterprise-ready extensions, management and monitoring capabilities via pgAdmin, and distributed-ready components. All Distributed Postgres components are now fully open source under the PostgreSQL License, including the Spock, LOLOR, and Snowflake extensions. pgEdge Enterprise Postgres VM Edition is available through a paid subscription, and the Enterprise Container Edition will launch in Q4. The company supports various operating systems and offers optional services, with a high Net Promoter Score from clients. pgEdge's clientele includes enterprises like Bertelsmann, Qube RT, Jobot, and the European Parliament, and it is backed by investors such as Akamai Technologies and Rally Ventures.