[Pgpool-general] pgpool.conf max_pool question
Janning Vygen
vygen at planwerk6.de
Wed Jun 7 22:24:33 UTC 2006
Hi,
i am a first time user of pgpool on debian stable Version: 2.5.2-1
i configured pgpool like this:
# number of pre-forked child process
num_init_children = 32
# numer of connection pool allowed for a child process.
max_pool = 2
now i have 64 database connections but all with the same username/database
pair, but manual says:
"pgpool will make a new connection if there's no user name and database name
pair yet."
ps ax | grep 'postgres: myuser mydatabase' | grep -v grep | wc -l
ps ax | grep '/usr/sbin/pgpool' | grep -v grep | wc -l
64
33
I had set max_pool = 2 because there is sometimes a different user connecting
but most of the time it is the same user to the same database. Is pgpool
working correct? Or did i miss something?
Another thing which is should be mentioned in the docs is the fact, that
pgpool has a listen queue and connections exceeding num_init_children are
queued. postgresql throws an error immedeatly. It would be nice if pgpool
does so too (or can be configured) as there is no need to have a backlog in
web environment. It is often better to not connect than to wait for an open
slot.
kind regards,
janning
More information about the Pgpool-general
mailing list