Pgbouncer

From: Raj <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Pgbouncer
Date: 2026-05-14 12:19:19
Message-ID: CAJk5Ata6-cjGenCxEyG2rTARNS6ETovWMX8SZYVvrDBtchSOXA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

App team using connection pooling and opening 500 sessions which seems to
me stay ,

In this case pgbouncer session pooling or transaction pooling which is
better?

Max_connections in db: 1000

Pool_mode=session
Max connections in pgbouncer: 3000
Default_pool_size=500
Reserve_pool_size=100
Min_pool_size=20

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adrian Klaver 2026-05-14 17:00:28 Re: Alter the datatype on all tables present in the database (bigint to varchar)
Previous Message Ron Johnson 2026-05-13 20:55:29 Re: Puzzling "INSERT has more expressions than target columns" error