[pgpool-general: 9255] Re: Question about the global pool

[Tatsuo Ishii]

>>> So that we
>>> can finally have the one and only pooler that we need which does it
>>> all? (load balancing, pooling, read-write split, etc)
>> Just out of curiosity, those features (load balancing, pooling,
>> read-write split) are already available in existing Pgpool-II
>> versions. What feature do you think lacking in current Pgpool-II
>> versions?
> I meant more efficient pooling (like pgbouncer), transaction-level
> pooling. Speaking of which pgbouncer also now supports prepared
> statements , any plans for prepared statements in Pgpool-II ?

For more efficient pooling, Usama's work should be useful and will be
in Pgpool-II 4.6.  Unfortunately the transaction-level connection
pooling will not be available in 4.6. According to Usama, he needs
more time to make it mature.

In my understanding prepared statements are already supported in
Pgpool-II 4.5.
> Allow to load balance PREPARE/EXECUTE/DEALLOCATE.
https://www.pgpool.net/docs/latest/en/html/release-4-5-0.html

Or do you mean something else?

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp