Doubt in pgbouncer
Hi All,
What is the limit value for fixing connection timeout issues?
As i searched in google and verified pgbouncer document
client_login_timeout
If a client connects but does not manage to log in in this amount of time,
it will be disconnected. Mainly needed to avoid dead connections stalling
SUSPEND and thus online restart. [seconds]
Default: 60.0
Can you pls suggest the best value ? or how to decide this parameter value
Regards
A.Rama Krishnan
There is no equation to determine the best value. It depends on your
environment.
Regards,
Ninad Shah
On Wed, 3 Nov 2021 at 19:18, Rama Krishnan <raghuldrag@gmail.com> wrote:
Show quoted text
Hi All,
What is the limit value for fixing connection timeout issues?
As i searched in google and verified pgbouncer document
client_login_timeoutIf a client connects but does not manage to log in in this amount of time,
it will be disconnected. Mainly needed to avoid dead connections stalling
SUSPEND and thus online restart. [seconds]Default: 60.0
Can you pls suggest the best value ? or how to decide this parameter value
Regards
A.Rama Krishnan