[Pgpool-general] connections not pooling

[Tatsuo Ishii]

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