[Pgpool-general] connections not pooling

[mark]

> -----Original Message-----
> From: pgpool-general-bounces at pgfoundry.org [mailto:pgpool-general-
> bounces at pgfoundry.org] On Behalf Of Guillaume Lelarge
> Sent: Friday, August 19, 2011 9:30 AM
> To: Johnny Tan
> Cc: pgpool-general at pgfoundry.org
> Subject: Re: [Pgpool-general] connections not pooling
> 
> On Fri, 2011-08-19 at 11:17 -0400, Johnny Tan wrote:
> > Thanks Tatsuo.
> >
> > I originally started with that (num_init_children=16), but then when
> > all connections were used, even though they were idle, new
> connections
> > would hang forever.
> 
> Sure, it's normal behaviour for pgPool. The pooling is done in session
> mode. It means that once a session is started, the pgpool process for
> this session is blocked. It cannot handle any other request.
> 
> 

I don't know if this question is more appropriate with this list or another,
but here it goes. 
I have:
Pgpool setup , verified in that seem to work with my psql sessions but my
config is probably junk. 

Pgbnech using -C to close the session after transaction. 

Gives me a hung bench if the number of clients from the bench exceeds
num_init_children. 

I understand that pgpool is only session pooling, but running pgbouncer in
session pooling doesn't give the problem of hung idle in transaction
connections. 


What should I be looking into ?