[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