Hum i see, so it is supposed to do that right, ok so if i want to do a sizing for the maximux of conections i can have for my server how could i do it? How could i test pooling then?
________________________________ De: Armin Nesiren [armin.nesi...@intera.si] Enviado el: miƩrcoles, 12 de octubre de 2011 01:22 p.m. Para: Matias Israel Malpica Escobar CC: pgpool-general@pgfoundry.org Asunto: Re: [Pgpool-general] PGpool not pooling... yes, but.. pgbench stops (not quits) when reach maximum number of connections.. that means pgpool is waiting to quit first connection before allowing another client to connect. But, there are 3 x 33 more child processes that are waiting for connection but with different connection parameters ( postgres: testuser Matt 127.0.0.1(55016) idle in transaction - this should be reserved for that...) On Wed, Oct 12, 2011 at 8:13 PM, Matias Israel Malpica Escobar <matias.malp...@thyssenkrupp.com<mailto:matias.malp...@thyssenkrupp.com>> wrote: # 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.nesi...@intera.si<mailto:armin.nesi...@intera.si>] Enviado el: miƩrcoles, 12 de octubre de 2011 01:14 p.m. Para: Matias Israel Malpica Escobar CC: pgpool-general@pgfoundry.org<mailto:pgpool-general@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.malp...@thyssenkrupp.com<mailto:matias.malp...@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@pgfoundry.org<mailto:Pgpool-general@pgfoundry.org> http://pgfoundry.org/mailman/listinfo/pgpool-general -- Armin -- Armin
_______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general