Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gC0DB-00024N-S9 for pgsql-admin@arkaria.postgresql.org; Mon, 15 Oct 2018 10:34:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gC0D9-0006fm-GV for pgsql-admin@arkaria.postgresql.org; Mon, 15 Oct 2018 10:34:55 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gC0D9-0006ff-5b for pgsql-admin@lists.postgresql.org; Mon, 15 Oct 2018 10:34:55 +0000 Received: from hermes.gatewaynet.com ([193.92.121.98]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gC0D5-0004Kw-94 for pgsql-admin@lists.postgresql.org; Mon, 15 Oct 2018 10:34:53 +0000 Received: from smadev.internal.net (pc131.internal.net [10.9.200.131]) by hermes.gatewaynet.com (8.14.3/8.14.3/Debian-9.4) with ESMTP id w9FAYfGE008376 for ; Mon, 15 Oct 2018 13:34:46 +0300 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.15.2/8.15.2) with ESMTP id w9FAYf7x021885 for ; Mon, 15 Oct 2018 13:34:41 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) Subject: Re: pgpool versus which tool? To: pgsql-admin@lists.postgresql.org References: From: Achilleas Mantzios Message-ID: Date: Mon, 15 Oct 2018 13:34:41 +0300 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:60.0) Gecko/20100101 Thunderbird/60.0.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------5CD6C17A96FAC4EA99C8EE8D" Content-Language: en-US X-Virus-Scanned: clamav-milter 0.98.7 at hermes X-Virus-Status: Clean X-Spam-Status: No, score=-19.7 required=5.0 tests=ALL_TRUSTED,DYN_HAM_COORD, DYN_HAM_IT,DYN_HAM_NAUTICAL,DYN_SPAM_MED6,DYN_SPAM_MED7,DYN_SPAM_PILLS_B, DYN_SPAM_SUBJ,HTML_MESSAGE,TW_PG autolearn=unavailable version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on hermes.gatewaynet.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------5CD6C17A96FAC4EA99C8EE8D Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit In the case of PAM authentication (the only way to do LDAP authentication) pgbouncer is haunted by some nasty bug(s) : https://github.com/pgbouncer/pgbouncer/issues/285 I don't know if pgpool handles PAM better under stress. On 15/10/18 1:00 μ.μ., Prince Pathria wrote: > Hey Pierre, > > go for pgBouncer if you want transaction based pooling and if your sole aim to use pgPool is for pooling then better go for pgBouncer. > pgBouncer performs 3x better than pgpool-II in benchmarking results. > > Thanks! > Prince Pathria > Systems Architect Evive +91 9478670472 goevive.com > > > On Mon, Oct 15, 2018 at 1:52 PM Thomas Kellerer > wrote: > > Pierre Ochsenbein schrieb am 15.10.2018 um 09:38: > > Which best of tool you recommend to replace pgpool? > What's wrong with pgPool that you think you need to replace it? > > And what is you requirement for such a tool? > -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt --------------5CD6C17A96FAC4EA99C8EE8D Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
In the case of PAM authentication (the only way to do LDAP authentication) pgbouncer is haunted by some nasty bug(s) : https://github.com/pgbouncer/pgbouncer/issues/285

I don't know if pgpool handles PAM better under stress.

On 15/10/18 1:00 μ.μ., Prince Pathria wrote:
Hey Pierre,

go for pgBouncer if you want transaction based pooling and if your sole aim to use pgPool is for pooling then better go for pgBouncer.
pgBouncer performs 3x better than pgpool-II in benchmarking results.

Thanks!
Prince Pathria
Systems Architect Evive +91 9478670472 goevive.com


On Mon, Oct 15, 2018 at 1:52 PM Thomas Kellerer <spam_eater@gmx.net> wrote:
Pierre Ochsenbein schrieb am 15.10.2018 um 09:38:
> Which best of tool you recommend to replace pgpool?
What's wrong with pgPool that you think you need to replace it?

And what is you requirement for such a tool? 



-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--------------5CD6C17A96FAC4EA99C8EE8D--