Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgpool versus which tool?

pgpool versus which tool?

From
Pierre Ochsenbein
Date:
Hi Guy's,

Which best of tool you recommend to replace pgpool?

Cheers,

Re: pgpool versus which tool?

From
Thomas Kellerer
Date:
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?

Re: pgpool versus which tool?

From
Prince Pathria
Date:
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?

Re: pgpool versus which tool?

From
Achilleas Mantzios
Date:
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

Re: pgpool versus which tool?

From
Pierre Ochsenbein
Date:
Nothing it's wrong with pgPool.

I would like to try with a new Middelware software to compare mechanism and relation with Load Balancing, HA, Failover..ect

Le lun. 15 oct. 2018 à 10:22, Thomas Kellerer <spam_eater@gmx.net> a écrit :
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?



--
Cordialement,

Pierre Ochsenbein
Mobile: +33668295394