Postgres Pro
Downloads
Home   >   mailing lists

Re: Doubt in pgbouncer - Mailing list pgsql-general

From Ninad Shah
Subject Re: Doubt in pgbouncer
Date
Msg-id CAOFEiBc4TAktXv2BU3H7qev0q2bvAoFw7VeSZtjFU_=tsC1yvg@mail.gmail.com
Whole thread Raw
In response to Doubt in pgbouncer  (Rama Krishnan <raghuldrag@gmail.com>)
List pgsql-general
Tree view
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:

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

pgsql-general by date:

Previous
From: Rama Krishnan
Date:
Subject: Doubt in pgbouncer
Next
From: Bryn Llewellyn
Date:
Subject: to_date() and to_timestamp() with negative years