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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1wP7Qj-000SVa-2g
	for pgsql-admin@arkaria.postgresql.org;
	Mon, 18 May 2026 23:31:26 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1wP7Qg-003TGA-2h
	for pgsql-admin@arkaria.postgresql.org;
	Mon, 18 May 2026 23:31:23 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1wP7Qg-003TG2-1X
	for pgsql-admin@lists.postgresql.org;
	Mon, 18 May 2026 23:31:23 +0000
Received: from mail-wm1-x32e.google.com ([2a00:1450:4864:20::32e])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1wP7Qf-00000000GuR-1tTb
	for pgsql-admin@lists.postgresql.org;
	Mon, 18 May 2026 23:31:23 +0000
Received: by mail-wm1-x32e.google.com with SMTP id
 5b1f17b1804b1-4891c0620bcso17495205e9.1
        for <pgsql-admin@lists.postgresql.org>;
 Mon, 18 May 2026 16:31:21 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec.at; s=google; t=1779147079; x=1779751879;
 darn=lists.postgresql.org;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=gEQBoAuxr+OajTAxpUc6zI6+x3jcRJcyliHpjsRuAWI=;
        b=pb1H00NX/J0FDyuPw8CLsuwJFNNv3YM0Q20nDhMDGf6e/e/sjtY/wRi8X5XAj6yCxC
         3xX4pMuN6ibC2NBhwxaZg5eQakVY2QkIgsjoUvGxeC5Cd/DGxICJJY7HCBIsRemRJfWL
         a8nln3WqxpUiMkj7knVNc1pT3tq22DNrmUbXDRYr6A9ZTsJBXxkrg+GQTNnQW+DROdiN
         nhxTN/BFZd8zHeRr4ZYHLYXRNwT37V9zpqj7rzcAQwu0DhIAn/+erzX7OLvi4g0hutds
         UfvevJ6lsChDXxU07Uuy7UY1N3EjCi/zetWQfWPYCDb7i7WiHIlODYpDsRnie0fRYXW9
         XQHQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20251104; t=1779147079; x=1779751879;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:x-gm-gg
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=gEQBoAuxr+OajTAxpUc6zI6+x3jcRJcyliHpjsRuAWI=;
        b=kNT9vRrRg0em88SHtMsHA9q6bCq2inc0GkJPi1UCzVejHSDLeWJcPQvktizFL3M0ou
         HfGebAfivPghrCMcpPLGGpAZxOih5kqfqKrExybrt024ECe2b0VOUwsvSY2hqLHSu4nm
         JIvwkRob4kKmLm5sSaqoC+Okenv+n83rBcptcmTdI36f6qJSwe8sja2ciLJlLXZdxKMU
         +KqKnHoYSNuLP/OGxcO6uS6AsTeYFXFS2On/VNd6L5xUKwSzuAprKHtNy737Imz9rhmO
         9e+7gH2891Ghi32tgwKfvYMA7U8NHsfSff0Ozigh9JWCZUn/QW4YpMv/i32skHjZhmT9
         sDag==
X-Forwarded-Encrypted: i=1;
 AFNElJ+AyvpGN/iCVfVJdRWm5pQCf0pmHaWNYuFAxs4iv6+Zb80dI1nYt7bNpY01lMWJYgyHJ2npFifFDgV+sQ==@lists.postgresql.org
X-Gm-Message-State: AOJu0Yzn7WodYYGlnYvjxTmXnSAUAt/4XfFr2hJhHQTJ1mPDEkR1/uEJ
	Pdy19LYNzsq/jkPHLYrc+xUEphthDlSeA46SmVFuWvQf3nW4ueC/NJvgBdhwjOj7o08=
X-Gm-Gg: Acq92OGud08iSfS3OlGmKYcepxkJq1522vdKgJEuSCYy+JaJpuOHggzlEJB12rhMbnp
	Cri8NdRwF1tM4RU9ypeHTBqP3lIhFnPuwnXwl3lSRbO3MHKumZxT2dXLaUR1FPsYAP1OwkARnbI
	GGYXImtNyKPlwyvcHxiM5ot2ZMpUjz905UI+cF+qdqQTHf7rvrbk2KsdqsZe/Dvj/h1PFOm5rG2
	B5xtAtUlNumU6cwg1C+ikdJD+4GzPF8iFYcc8dyqO0K//kkRh3xi9PhyeSze1UXPbjXAowMxHvI
	slZOR3BeRvKSYhrZUnvpVGuyo60NVxuOw2RWAdIxkx2kNIDFpzVEJ0rvVctbCDpj4cl2ihUfgu4
	hxP0GaK1GQG6VmScR0RlUhfkY9MVzjIDsAmETMCWCdYC1vEo/HIK5VQAg6I3Us2NPMpi72aDLQ3
	67vbTbsmK4XvR87wShFWNGoywZJsrSGBVSBottne3s04TTO/rEZt4=
X-Received: by 2002:a05:600c:2d09:b0:48f:e1ac:c96d with SMTP id
 5b1f17b1804b1-48fe61f2bcemr151419095e9.20.1779147079162;
        Mon, 18 May 2026 16:31:19 -0700 (PDT)
Received: from laurenz.albe-K4N0CV00F97414D ([24.109.50.222])
        by smtp.gmail.com with ESMTPSA id
 98e67ed59e1d1-36951059f4dsm11599867a91.0.2026.05.18.16.31.17
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Mon, 18 May 2026 16:31:18 -0700 (PDT)
Message-ID: <6bea4078a966504a8099d4d4fe6be8464f55eefb.camel@cybertec.at>
Subject: Re: Pgbouncer transaction pool mode
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Raj <rajeshkumar.dba09@gmail.com>, Pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Mon, 18 May 2026 16:31:17 -0700
In-Reply-To: 
 <CAJk5AtaLqWznVtW3NULM-OC1oHsse6o=SizajiB7qQya91C_jQ@mail.gmail.com>
References: 
	<CAJk5AtaLqWznVtW3NULM-OC1oHsse6o=SizajiB7qQya91C_jQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) 
MIME-Version: 1.0
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/6bea4078a966504a8099d4d4fe6be8464f55eefb.camel%40cybertec.at>
Precedence: bulk

On Mon, 2026-05-18 at 16:31 +0530, Raj wrote:
> Could you share me your pgbouncer configuration for transaction pool mode=
.

pool_mode =3D transaction

Have a look at the documentation!

Yours,
Laurenz Albe