[pgpool-hackers: 269] Re: transaction pooling mode?

[Tatsuo Ishii]

> Hi Tatsuo,
> 
> Having a transaction pooling mode in pgpool certainly sounds like an
> interesting idea. So right now as i understand we have session pooling in
> pgpool which mean that connection will only return to the pool once client
> session is disconnected. Using the transaction based pooling can be helpful
> in cases where we have to manage a very high number of concurrent
> connections with short life span however the transaction based pooling
> needs to be used carefully by the customer application in order to make
> sure that it doesn't break any application features.

Right.

> So in short, I agree that it would be a interesting feature to add to
> pgpool. Do we know if they are real users in the field that use this method
> of pooling in pgbouncer? Have they reported any issues with this?
> 
> Are you considering this as a 3.4 feature?

Yes, but to be honest, still I'm not convinced yet if the feature is
worth the work needed to implement it. Maybe we can evaluate
pgbuncer+pgpool cascading system first to see if it's really usefull.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp