[Pgpool-general] Number of connections and load balancing

Josh Berkus josh at agliodbs.com
Tue Jul 19 21:41:01 UTC 2011


Tatsuo, all:

As far as I can tell, pgPool makes a connection to each backend for
every connection on the front-end.  That is, if you have a 4-server
cluster and allow 100 connections, you will have:

client-pgpool: 100 proc
pgpool-db1: 100 proc
pgpool-db2: 100 proc
pgpool-db3: 100 proc
pgpool-db4: 100 proc

Is this correct?

If I'm load-balancing between db1-4, it seems like I don't need to have
a equal number of connections for each server.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


More information about the Pgpool-general mailing list