Get the latest tech news
Benchmarking PostgreSQL Connection Poolers: PgBouncer, PgCat and Supavisor
Benchmarking PostgreSQL connection poolers: PgBouncer, PgCat and Supavisor
PgBouncer’s limitations are addressed in PgCat, which is described as a connection pooler and proxy that allows sharding, load balancing, failover and mirroring. Its setup is a bit more involved, as it requires an additional auxiliary database to store tenants information, plus there are more listening ports in play. However, its downsides are: (1) it is single-threaded, preventing it from fully utilizing the machine with a single instance, and (2) if there is a surge in the number of connection requests, clients would right away notice some performance degradation (at least in my environment).
Or read this on Hacker News