[Pgpool-general] PGpool not pooling...

[Armin Nesiren]

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.Malpica at 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.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> 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
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>
>>
>
>
>  --
> Armin
>



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