[pgpool-general: 9168] Re: pgpool-II 4.4 vs 4.5 as a pooler

[Bo Peng]

Sorry for the late response.

Thank you for using and testing Pgpool-II.

> So, before I get my hands dirty with 4.5, I'd like to ask if there has 
> been any progress to the pooling part. Currently we rely on pgbouncer 
> using LDAP (via PAM) individual connections for users. Using two 
> systems, pgbouncer in front of the app and pgpool in front of the db, 
> kind of adds latency so we are exploring all options.

The connection pooling feature in 4.5 has not changed since 4.4.

The global connection pooling feature currently being developed by Usama
is expected to be introduced into the next major version 4.6.

On Fri, 28 Jun 2024 12:29:50 +0300
Achilleas Mantzios - cloud <a.mantzios at cloud.gatewaynet.com> wrote:

> Dear pgpool community
> 
> I had the chance to talk to Muhammad Usama of Percona back in pgconf.eu 
> 2023 last year in Prague. He told me that the community is working 
> towards making pgpool better as far as pooling is concerned. I had kind 
> of extensively tested 4.4 and was very much happy with the core team's 
> responsiveness and eagerness to solve problems. Life took me to other 
> trails in the meantime, but here we are again, thinking seriously about 
> pgpool once again, as a SQL proxy, SQL router, and SQL caching solution.
> 
> So, before I get my hands dirty with 4.5, I'd like to ask if there has 
> been any progress to the pooling part. Currently we rely on pgbouncer 
> using LDAP (via PAM) individual connections for users. Using two 
> systems, pgbouncer in front of the app and pgpool in front of the db, 
> kind of adds latency so we are exploring all options.
> 
> Thank you!


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/