> 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.
That's normal and probably I should add to FAQ:-) pgbench opens all connections to backend(in this case pgpool) in start up of each transaction even if -C option is provided. pgbench won't move to next phase unless all connections oppned and no connection will be closed. This is a kind of deadlock situation... -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp > 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 > Pgpool-general@pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
