Re: Discard All in pgbouncer

Поиск
Список
Период
Сортировка
От Rajesh Kumar
Тема Re: Discard All in pgbouncer
Дата
Msg-id CAJk5AtYQTC2bc3Sba=r+LqjNa=XZuV7HnSqoNPbtoOm7t3TWkA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Discard All in pgbouncer  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Discard All in pgbouncer  (Michael Banck <mbanck@gmx.net>)
Re: Discard All in pgbouncer  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
Purpose of bouncer is handle idle connections right? Is there a time period for the DISCARD ALL to go away? If so, how to configure?

The part I don't understand is if bunch of connections in the name of Discard all is idle ,  what difference it make?

If I have set Max conn in db as 250....do I have to set the same in pgbouncer?

On Mon, 9 Oct 2023, 19:46 Ron, <ronljohnsonjr@gmail.com> wrote:
On 10/9/23 09:07, Rajesh Kumar wrote:
Hi,

I could see queries like DISCARD ALL is idle for more than 5minutes (we are using pgbouncer).

Why is it idle for more than 5mns? I read about pgbouncer and could not understand this thing. If resetting a connection using query becomes one idle connection, I don't understand the pooling system here

In your case, "Idle" just means that DISCARD ALL was the last statement that the pid executed.  Now, it's just doing nothing, because there's nothing to do.  IOW, this is just fine.  No need to worry.

--
Born in Arizona, moved to Babylonia.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Discard All in pgbouncer
Следующее
От: Michael Banck
Дата:
Сообщение: Re: Discard All in pgbouncer