[Pgpool-general] Pgpool maximum number of children

"Stéphane A. Schildknecht" stephane.schildknecht at postgresqlfr.org
Wed Apr 9 08:38:43 UTC 2008


Hi,

By default, pgpool is configured with :

# Number of pre-forked child processes
num_init_children = 32

# Number of connection pools allowed for a child process
max_pool = 4

I wonder how it works in reality.

What would be the best value to give these paramters if I want mu pg server to
accept 200 connections ?

Would it be relevant to have
NIC=200
MP=1

or

NIC=50
MP=4

First in the case I have a single database on my PG server, and second if I
have to distinct databases.

Thanks for any help to understand the policy behind these two parameters.

-- 
Stéphane SCHILDKNECHT
Président de PostgreSQLFr
http://www.postgresql.fr


More information about the Pgpool-general mailing list