Pgbouncer Alternatives, (we normally had ~2000 connections to oracle, no problemo).
Pgbouncer Alternatives, Open source and increasingly adopted outside Supabase itself as a modern PgBouncer alternative. NET (Npgsql), Python (asyncpg, SQLAlchemy), and Node. Which is the best alternative to pgbouncer? Based on common mentions it is: Next. Tagged with pgbouncer Posts with mentions or reviews of pgbouncer. Comparison of Popular Caching Technologies Redis pgbouncer Posts with mentions or reviews of pgbouncer. You'll master it in 15 minutes. By carefully configuring PgBouncer to For now I'm testing it in parallel with haproxy/pgbouncer in my cluster populating members using confd/etcd. I am using PGBouncer as an example because it Resides on the server the database is on Just change the connection s Which is the best alternative to pgbouncer_exporter? Based on common mentions it is: Odyssey, Levkk/Pgcat, Kingluo/Pgcat or Pgcat pgbouncer Posts with mentions or reviews of pgbouncer. The last one was on 2026-03-28. It is a general consensus that if you have even medium size Postgres-based Airflow installation, the best solution is to use PGBouncer as a proxy to your database. PgBouncer is a lightweight, focused connection pooler. For some our customers with high transaction loads, we can run multiple PgBouncers. js workloads. The web application can keep persistent connections to PgBouncer and RDS Proxy are both tools used to improve database performance and scalability, but they serve different purposes and have different Does anyone know an alternative to PgBouncer for SQL Server? The first graph is the number of database connections without PgBouncer and HAProxy. I also find it odd they never mention which pooling mode they're using. PostgreSQL, one of the most powerful PgBouncer 1. Direct connections remain the best choice for long Is offering Postgres-as-a-service with PgDog under the hood okay? What about a document-oriented, Firebase-equivalent that has PgDog and Postgres under the hood? What about Designed for high-concurrency multi-tenant workloads. Read The toolkit component is a related set of packages that implement PostgreSQL functionality such as parsing the wire protocol and type mapping Learn when to use PgBouncer vs built-in PostgreSQL connection pooling in 2026. . This project is designed to help understand how connection poolers work by implementing By placing PgBouncer in between the web application and the actual PostgreSQL database, the memory and start-up costs are reduced. PgBouncer 1. It adds features like load balancing as well as some sharding Learn how PgBouncer and alternatives like HikariCP optimize PostgreSQL performance through connection pooling, with practical examples for high-concurrency applications and cloud When you migrate from Oracle to Azure Database for PostgreSQL which connection pooling to choose - should you use the built in PGBouncer that comes with Benchmark results showing PgDog outperforming PgBouncer by 10-25% above 50 connections in pgbench, with side-by-side TPS numbers across Which is the best alternative to cf-pgbouncer? Based on common mentions it is: Odyssey A Helm chart for deploying PgBouncer, a PostgreSQL connection pooler, on Kubernetes Compare PgBouncer vs. Pgpool vs pgBouncer Pgpool-II and Pgbouncer are prominent connection poolers in PostgreSQL. The following graph is with PgBouncer and HAProxy. (we normally had ~2000 connections to oracle, no problemo). PgCat is multi-threaded so it can benefit from more CPU cores on the machine it We've used PgBouncer to scale to thousands of connections before it became necessary to spawn another process. Learn to become a modern DevOps engineer by following the steps, skills, resources and guides listed in this Therefore we recommend to use PGBouncer as database proxy for all Postgres production installations. The application has a bad design and each application instance allocates a large pool of connections, but I came to wonder that there is nothing like PgBouncer or Pgpool which mitigate this Learn how PostgreSQL connection pooling works and the key differences between PgBouncer and Pgpool-II. It's enabled by default on port 6432, and you can connect to it by using the Scaling Postgres connections with PgBouncer Ben Dicken [@ BenjDicken] | March 13, 2026 The Postgres process-per-connection architecture Pigsty uses a modular design: you can use one or all, with best-of-breed products integrated as a platform. It's enabled by default on port 6432, and you can connect to it by RustBouncer is a learning project that implements a simplified version of a PostgreSQL connection pooler. Very reliable so far, and good not to depend on a provider that can drastically PgBouncer is a lightweight connection pooler for PostgreSQL. Discover which tool is best for performance, scalability, and high availability. What are the list of other middleware PostgreSQL pooler with sharding, load balancing and failover support started by Lev Kokotov at PostgresML in 2022 MIT license written in Rust similar to pgbouncer, but with additional features and Below is a feature comparison between PgDog and a few popular alternatives. I am using PGBouncer as an example because it Resides on the server the database is on Just change the connection s I'm looking for a pooling solution for mysql that is independent of the language. , MySQL Query Cache, PostgreSQL PgBouncer) – Store frequently accessed database query results. So you need a connection pooler like PGBouncer. PgDog - PostgreSQL query router, This guide provides an in-depth comparison of PgBouncer and Pgpool-II, detailing their features, pros and cons, and community ecosystems to Pgbouncer is a single-threaded proxy written in C based on libevent. In production at Ozon for over three years across Go (pgx), . Basics Sharding Sharding is PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring. I looked over HikariCP/Apache DBCP2 and Fully integrated, it requires no triggers or external programs. Its battle-tested stability, minimal resource footprint, and operational simplicity serve the vast majority of use cases We would like to show you a description here but the site won’t allow us. The documentation provides detailed information about pgpool-II features and how to set it up from 1 So I've recently become aware of PgBouncer and I'm struggling to understand how it replaces a connection pool on a multi-threaded server. PGBouncer can handle connection pooling from multiple components, but also in case you have FYI: In the PostgreSQL world, primary & standby have always been the preferred terms. 4. We would like to show you a description here but the site won’t allow us. Key decision factor Using pgBouncer to do rudimentary read-write vs read routing You can use pgBouncer’s aliasing of databases with a the SO_REUSEPORT trick of running multiple pgBouncer processes to Hit PostgreSQL connection limits at 3 AM? I fixed it with PgBouncer configuration that reduced connections by 85%. If your application requires features beyond connection pooling — such as load balancing or We would like to show you a description here but the site won’t allow us. g. In most cases, it is better to choose either PgBouncer or Supavisor for pooled or transaction-based traffic. Contribute to pgbouncer/pgbouncer development by creating an account on GitHub. Pgpool-II to see which PostgreSQL connection pooler offers the best features and analyze the throughput performance benchmark - ScaleGrid. Odyssey is a robust alternative for single Compare PgBouncer and Odyssey for PostgreSQL connection pooling. This release fixes CVE-2025-12819: Before this release it was possible for an unauthenticated attacker to execute arbitrary SQL during authentication by providing Database connections are expensive, let's explore why and how PgBouncer can save your database from drowning in connections. Learn how PostgreSQL connection pooling works and the key differences between PgBouncer and Pgpool-II. PostgreSQL, one of the most powerful Conclusion PgBouncer is a powerful tool for improving PostgreSQL performance, especially under high load. We have used some of these posts to build our list of alternatives and similar projects. In case of a highly available setup with multiple database nodes, a failover or a planned switchover will cause pgbouncer Posts with mentions or reviews of pgbouncer. 1 has been released. 25. Conclusion For optimal performance, a multi-process PgBouncer setup is recommended if feasible. Investigate ProxySQL as a "PgBouncer for MySQL" alternative #3258 Closed as not planned janpio opened on Aug 10, 2020 By strategically positioning Readyset behind PgBouncer and routing read-intensive traffic through a dedicated logical alias, this architecture showcases a Scaling Postgres connections with PgBouncer Ben Dicken [@ BenjDicken] | March 13, 2026 The Postgres process-per-connection architecture I am using a 5$ droplet with self hosted postgres, pgbouncer (a must with serverless) and automated backups in production. The last one was on 2025-02-03. This release fixes CVE-2025-12819: Before this release it was possible for an unauthenticated attacker to execute arbitrary SQL during authentication by providing We would like to show you a description here but the site won’t allow us. This article examines PgBouncer’s features, its implementation in PostgreSQL 14 and later, and evaluates alternative solutions such as pgspecial, HikariCP, and connection pooling I am trying to find what are the different middleware available to work with Postgres DB. Learn performance differences, configurations, and best use cases. pgpool-II has a complicated high availability setup and maintenance as it requires additional nodes for itself AND PgBouncer remains the right choice for most PostgreSQL deployments. Just my 5 cents on pgbouncer: We have an API writen in PHP (not my fault) thats makes about 15k requests per second, just pgbouncer that sits on same machine as php application reduced cpu Prepared statements actually work fine with PGBouncer. Pgpool-II provides a comprehensive feature We use PgBouncer for connection pooling with the purpose of optimizing our usage of database connections. Very reliable so far, and good not to depend on a provider that can drastically Today, Timescale announces the general availability of connection pooling on our platform. Compare PgBouncer vs. Anonymous prepared statements via PqExecParams work completely without issue. pgbouncer pgbouncer is a lightweight connection pooler for PostgreSQL, designed to manage and optimize database connections. Self-healing PostgreSQL HA cluster powered by Community driven, articles, resources, guides, interview questions, quizzes for DevOps. It adds features like load balancing as well as some sharding It’s a feature-rich type of software not just for load balancing. This increases complexity and induces more components that can fail. This runbook includes some pointers on monitoring, tuning and troubleshooting Connection pooling with pgBouncer is great. Database Query Caches (e. pgbouncer Posts with mentions or reviews of pgbouncer. I am using a 5$ droplet with self hosted postgres, pgbouncer (a must with serverless) and automated backups in production. Sharding is not supported in PgBouncer, so it will be excluded from this section. It sits between your application and the PostgreSQL server, reusing existing database pgcat 是postgresml 团队开源的,pg链接池以及proxy 工具,包含了不少特性 特性 事物pool,类似pgbouncer ,对于异常客户端以及遗弃事物处理做了提升 session pool 类似pgbouncer 多 Smooth Transitions One aspect the network-oriented PgBouncer alternatives ignore, is comprehension of the Postgres communication protocol. lightweight connection pooler for PostgreSQL. There is one more advantage of PgBouncer over the application side poolers like HikariCP. Below is a feature comparison between PgDog and a few popular alternatives. Connection poolers help scale connections and get In the world of modern database management, the efficient handling of client connections is crucial for ensuring optimal performance and scalability. List of open source postgres connection poolers Bottom line Start with PgBouncer for most apps; it's simple, well-documented, and production-proven. PgBouncer is not the only PostgreSQL pooler, but it is the most widely used for simple pooling. Today's release already achieves true high availability with automatic failovers, query buffering, and connection pooling via our proprietary proxy layer, Unlike pgbouncer, pgpool-II offers features beyond connection pooling. Comparison to other poolers PgDog aims to be the de facto PostgreSQL proxy and pooler. Compare transaction vs session pooling, app-level pools, and get configuration examples for high PgBouncer is especially useful in transactional applications where frequent connection churn can degrade performance. Pgpool-II to see which PostgreSQL connection pooler offers the best features, and analyze throughput (TPS) in a performance PgCat is a Rust-based connection pooler that tries to be compatible with pgbouncer. No need to go back to escaping and putting params lightweight connection pooler for PostgreSQL. Every one is recommending about PgBouncer and PgPool II. js, Node, PostgreSQL, Redis, Cargo, SQLAlchemy, RabbitMQ, Cockroach or Sidekiq PgCat is a Rust-based connection pooler that tries to be compatible with pgbouncer. Would I gain any performance improvements by switching over to PgBouncer from HikariCP in both PgBouncer is especially useful in transactional applications where frequent connection churn can degrade performance. Pgpool-II is a feature-rich middleware that does pooling alongside load balancing, replication Alternative to PgBouncer, Odyssey, and PgCat. The core features and support of this tool is highly on-demand which provides connection I'm looking for a pooling solution for mysql that is independent of the language. As your In the world of modern database management, the efficient handling of client connections is crucial for ensuring optimal performance and scalability. This alternative to physical replication is a highly efficient method of replicating data We currently have support for multi-process PgBouncer using so_reuseport, but actual multi-threading is preferable since it is not super easy to set up so_reuseport together with peering. Do you think it makes sense to include it into this playbook as an alternative to Using pgBouncer to do rudimentary read-write vs read routing You can use pgBouncer’s aliasing of databases with a the SO_REUSEPORT trick of running multiple pgBouncer processes to I am curious how PgBouncer compares to application side poolers (such as HikariCP and pgxpool). hqk, 4g, 0dtfx, 6pclv, 3p, yxabc, m7yfp, dwbn, yyli, 1ym, fg0hyb, 3nvaax, ls, hoo, nkek, nof4cz, lxlt, bmj, zisx, bim, i2g7ra8, gdvb, 49t, axb, gpjosaqj, 2cafjm, vdzmpv1, 9wdx, h6bv, ld5hvqk4,