On Fri, 2011-10-07 at 15:45 -0400, Brandon Phelps wrote: > Forgive me, I'm still a bit confused by how max_pool works with num_init_children. First you said that at most I can have 32 clients sending queries, but then you said that each process can handle 4 different connections... so does this mean that I can have 128 connections from pgpool to my postgresql database? > That's right. You'll have, from pgpool, a maximum of num_init_children*max_pool connections (IOW, 128 with your connections). Out of these 128 connections, only 32 will be active at one time. I'll try to explain it another way. When client C1 connects to PostgreSQL via pgpool, it will use one of the four possible connections of a pooler process. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
