public inbox for [email protected]
help / color / mirror / Atom feedFrom: Raj <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Pgbouncer
Date: Thu, 11 Sep 2025 19:01:26 +0530
Message-ID: <CAJk5Atanc-d4xg_3UxbTybvNmPfb593WAhLFqjAWEUhm5cYQDQ@mail.gmail.com> (raw)
We are migrating from oracle.to postgres and its done.
Now as a DBA, to improve performance say idle connecting handling or
anything, if I want to recommend pgbouncer to the team, what's the
compelling reason would it be?
I may ask them to handle connections from application end and they may say
ok but we still.may see idle connections are not closed.
So, at point and for what compelling reason I should tell my manager, we
must go-ahead and use etc.
We use pg17 and in postgres itself I know idle_session_timeount,
transaction_timeout, statement_timeout. Is this enough? Will it abruptly
kill queries and if so, isn't it bad?
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Pgbouncer
In-Reply-To: <CAJk5Atanc-d4xg_3UxbTybvNmPfb593WAhLFqjAWEUhm5cYQDQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox