Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wbIAR-002R0I-04 for pgsql-admin@arkaria.postgresql.org; Sun, 21 Jun 2026 13:24:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wbIAP-0035K1-37 for pgsql-admin@arkaria.postgresql.org; Sun, 21 Jun 2026 13:24:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wbIAP-0035Jt-1t for pgsql-admin@lists.postgresql.org; Sun, 21 Jun 2026 13:24:53 +0000 Received: from mail-lj1-x234.google.com ([2a00:1450:4864:20::234]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wbIAO-00000001RT6-1MLM for pgsql-admin@lists.postgresql.org; Sun, 21 Jun 2026 13:24:52 +0000 Received: by mail-lj1-x234.google.com with SMTP id 38308e7fff4ca-396bed274b9so34457531fa.0 for ; Sun, 21 Jun 2026 06:24:51 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782048289; cv=none; d=google.com; s=arc-20240605; b=P/daQtUmwPtpNSrwRxYCQft+XD/PEkTixQiRlOEB3CcQ6aIprAo6qzwTuBhclH/Nhb 3glO0WQvSUqsJEMl0AEm0NGWHtP4w3Lmit1FUMRQlYafvv255bTsd5EplcOuwuTYSZTT nJzbShDzMI+cTYf4t0vfgKLXB9ULTK93oDgekfaUqwebuG9YOoo3ALJdQfJDV/DES2p8 pzApH0oVYFnx39OEH6zq6tANd4t+C9ooRhnvCgd5e4QLRBT81iDi7yOq03JJ+6CkrVId 4KMVgQSSkNpfNF4zcnwvP9G/jH3jkrG/5VULrdQD926oM+gW7OPqTFlJvie0zx5YaAjP 8Kdw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=uLmVy/xWDtYBxie14I/TXgwcRe9LSOS7/i7kzq1It1g=; fh=druxZHa2fk4e6MLibibygn9AWWgeaAPo4m8Gpo2MBXU=; b=FsHhDjwIw+gJt940V1Db+89aeOTATmYxqqLlEkfLbEYH9bhqTX6jXJyB8AD+saQZZ7 7l9Lp2RG+ZSgsltRWsHBdrbDwYDawyXZ8yBP241Q/gKLpFYo0KsB6e3fQbp67orYkmQU l2R40OVQbB+SzPx33/8zNz99qmVeQk25Z/OdCZZWmRVVoEmcUgzhpKNRFHx0jPn/Wy6j xMMeWdANRRc7lAxZi5bksxnc5mGkkxxPtctMLYR8mMqrfF6j9Qk/QITtnWIeCvSaU/mC cn/iz/NKy73N6zcopMdwwcQBt50ImLX78YW6EOfjzim8cUh4ugsk9md7T1PAayrJEe36 npFw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1782048289; x=1782653089; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=uLmVy/xWDtYBxie14I/TXgwcRe9LSOS7/i7kzq1It1g=; b=XKti3OG6EYB5S5Bf4KMLiZJLO9jfoUv+CD4VDH1gL051VKYeYZpknt8SkKbRNd8ctF c8zodpO9P0AHAHEK3EaICR8tFuBjXc+lWUqnQeASt3CQF8eHO6jTWQ63bXMkvPVPFiad fEc17hOojOevyphgB/KAgg3ePihYWVFe9XkKGoePhvSmhxh2/J9bDqGvMyDmWi376ZIo 5wiJBwtajj5u2hxpyr8sUHgyX0jUIPVwE0HMNbLqgGUhUEZamLNYxIpeko7YGX6Z6RNk QzzUwvevZPd28YUdLBzymEszzQc9e0OSKd1D/kZr6EzGmKwhc9MPf1xw71cH8aeC4dXI BngQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782048289; x=1782653089; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=uLmVy/xWDtYBxie14I/TXgwcRe9LSOS7/i7kzq1It1g=; b=hBWcZeqTnc+7Bhss6kPTsk9npZjOWv4CIi+GwVM6Kr0a02IE8qs7JsLveL+koURMGA ZQJMhwxdz1q6xRg3uyO8zymxFXMzkJnG9Gyhk0ca07sdRLQqhwx2nQbXGw9ZCDuDGpul ftn6wyzAapLbuiDVnwfvXd2+n5qKT6OcI3ljyjDRA7hBqSRBfnueZFHX8Fy5vY0dTMg0 hv4KsVFMRhV856DlsKG3kQvCs/JEj6E71ZMx6/ZEt9Pz2P99Sb5kCTrHam3GUPt+n7OV VMNeB23HeGTJw08XpzBDxH1wnBc3A1b4DabSOFyaMutrcf6coXp7nnGfIxRMFLuOJpeC octQ== X-Gm-Message-State: AOJu0YxASpZMXKPlk7tdJXqT7cjB39KskfgFyNFfcJ51ZEEpROo1IAA8 2Qds8zLo9Opq7bveADptYAHlIl6oQ4ZiigZ6QKib/oG7/eYzOSiDyyAH+Nn+OUR+FeTZDhYbwbz 2E+5leeiBKPpcWv/uwS9eE1QCZ4tQpeEtOA== X-Gm-Gg: AfdE7cmrlBQXB14wz6k90ISAB4Lwj8EWacAn22IMXx5XpDGuh1Xekx0oc0B02R7yECS 7eGx92ELjpi7ojnxOWd4SlfOMBrQt/76amFiNE/IqGIhqviFmLNTa3+IZY+7iUskt9hGNLUv3OJ EnsAgxW6XXkQzrNcCzXwz3xXfbNpleL54Afc0yylvZ6vv7MIyLtkDR7SFrtLfyRLQ6uo2dBmbtg /ZJEX0AOLd3qQXxVTqUtZpJ8bVJWRp/N6ZYgnhHZOQAcHPfqapYZAgD+evrgch+3U/bIkLMThid LVVLNonM8WytUQ== X-Received: by 2002:a2e:bd09:0:b0:38e:8102:cbdd with SMTP id 38308e7fff4ca-3998a0f486amr27716261fa.3.1782048288587; Sun, 21 Jun 2026 06:24:48 -0700 (PDT) MIME-Version: 1.0 From: Raj Date: Sun, 21 Jun 2026 18:54:37 +0530 X-Gm-Features: AVVi8CewMIxuJUbIswjy6DzPz6n3ObWVKLZlf08taYdbA2KWRAkwxGha4fiw0eE Message-ID: Subject: TPS in direct Postgres Vs TPS in pgbouncer To: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000036c1e60654c373b4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000036c1e60654c373b4 Content-Type: text/plain; charset="UTF-8" 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. --00000000000036c1e60654c373b4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi All,

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

When th= ey use pgbouncer, they get 50% reduction in TPS.
What are general advices?
<= br>
My set up is 3 node PATRONI, where=C2=A0 node3 i= s DR and manual failover.

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


=
--00000000000036c1e60654c373b4--