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

[Achilleas Mantzios - cloud]

On 7/8/24 10:08, Bo Peng wrote:
> 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.
Thank you!! This is some great news!
>
> 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!
>