Обсуждение: Doubt in pgbouncer

Поиск
Список
Период
Сортировка

Doubt in pgbouncer

От
Rama Krishnan
Дата:

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

Re: Doubt in pgbouncer

От
Ninad Shah
Дата:
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