TPS in direct Postgres Vs TPS in pgbouncer

From: Raj <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: TPS in direct Postgres Vs TPS in pgbouncer
Date: 2026-06-21 13:24:37
Message-ID: CAJk5AtYBpy2ROKzv+se+LXpM4PZdzifnY_rZvamjHpBELxYUog@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

When the application team is using posytgres directly for 17.9 version,
they get necessary TPS.

When they use pgbouncer, they get 50% reduction in TPS.

What are general advices?

My set up is 3 node PATRONI, where node3 is DR and manual failover.

Two nodes (node1 and node2) are in site A ..having haproxy, pgnouncer is
bound with haproxy.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jorge Batista 2026-06-21 14:37:06 RE: TPS in direct Postgres Vs TPS in pgbouncer
Previous Message Aleksey M Boltenkov 2026-06-18 20:33:20 Re: AW: Size of /pgdata