A nice gain? Bro, this is 1200% performance increase!!! I feel like a caveman working without a pooler for so long. Still, I have raised my own questions regarding authentication between the application and pgBouncer and between pgBouncer and Postgres, but this seems really helpful!
Did I misunderstand something? I googled that the Postgresql can manage more thousands of transactions per second, but in the video, he mentioned up to 350 transactions per second?
Thanks for sharing.. a quick question. .currently I have 1 HAProxy + 3 Postgres Server (using Patroni).. does't it make sense to put PgBouncer in front of the HAProxy ? Clients -> PgBouncer -> HaProxy --> PG Cluster. Or Clients -> HaProxy -> PgBouncer ( * 3) -> PG Cluster?