TPS in direct Postgres Vs TPS in pgbouncer - Mailing list pgsql-admin

From Raj
Subject TPS in direct Postgres Vs TPS in pgbouncer
Date
Msg-id CAJk5AtYBpy2ROKzv+se+LXpM4PZdzifnY_rZvamjHpBELxYUog@mail.gmail.com
Whole thread
Responses RE: TPS in direct Postgres Vs TPS in pgbouncer
Re: TPS in direct Postgres Vs TPS in pgbouncer
List 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.


pgsql-admin by date:

Previous
From: "William Sescu (Suva)"
Date:
Subject: AW: Size of /pgdata
Next
From: Jorge Batista
Date:
Subject: RE: TPS in direct Postgres Vs TPS in pgbouncer