> -----Original Message----- > From: [email protected] [mailto:pgpool-general- > [email protected]] On Behalf Of Guillaume Lelarge > Sent: Friday, August 19, 2011 9:30 AM > To: Johnny Tan > Cc: [email protected] > 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 ? _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
