[Pgpool-general] PGpool not pooling...

[Matias Israel Malpica Escobar]

# number of pre-forked child process
num_init_children = 33
# Number of connection pools allowed for a child process
max_pool = 4
i know that number is set to 33 while im trying to connect 34 but it should put in a queue right?
________________________________
De: Armin Nesiren [armin.nesiren at intera.si]
Enviado el: miércoles, 12 de octubre de 2011 01:14 p.m.
Para: Matias Israel Malpica Escobar
CC: pgpool-general at pgfoundry.org
Asunto: Re: [Pgpool-general] PGpool not pooling...

What is your values for
num_init_childern and max_pool
in pgpool.conf ?

On Wed, Oct 12, 2011 at 8:00 PM, Matias Israel Malpica Escobar <Matias.Malpica at thyssenkrupp.com<mailto:Matias.Malpica at thyssenkrupp.com>> wrote:
HI i am testing pgpool with pgbench, i am running the following:

pgbench Matt -U testuser -p 9999 -c 34 -t 10 -C -d
An i am noticing that when the conection goes up to the 32 client it stops working

client 32 executing \setrandom delta -5000 5000
client 32 sending BEGIN;
when i go to ps -aux i can see this in each process

postgres: testuser Matt 127.0.0.1(55016) idle in transaction

i already checked the pgpool.conf file and the maximun child conections option is set to 32 but from what i understand pgpool should put the remaining 2 conecntions in queue right?

connection_cache = true
What am i doing worng???

_______________________________________________
Pgpool-general mailing list
Pgpool-general at pgfoundry.org<mailto:Pgpool-general at pgfoundry.org>
http://pgfoundry.org/mailman/listinfo/pgpool-general




--
Armin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20111012/4b618916/attachment.html>