SYSTEM Cited by 1 source
Pgpool-II¶
What it is¶
Pgpool-II (pgpool.net) is a middleware between Postgres clients and servers that provides connection pooling plus several other features: load balancing across replicas, query replication, parallel query execution, and in-memory query caching.
Compared to PgBouncer, Pgpool-II is a more ambitious, feature-rich middleware — but also more heavyweight, with more operational surface area to manage.
Seen in¶
- sources/2020-06-23-zalando-pgbouncer-on-kubernetes-minimal-latency — evaluated and rejected by the Zalando Postgres Operator in favor of PgBouncer. Kukushkin: "Pgpool-II can actually do much more than just connection pooling (e.g. it can do load balancing), but it means it's a bit more heavyweight than others." The operator chose the simpler, more focused pooler.
Related¶
- systems/pgbouncer — the simpler alternative, chosen over Pgpool-II by Zalando.
- systems/odyssey / systems/pgagroal — newer performance-optimised alternatives.
- systems/postgresql