| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Discard All in pgbouncer |
| Date: | 2023-10-09 14:22:01 |
| Message-ID: | 753F56B9-3E71-4CB7-91DC-70BF3C8E4EC7@elevated-dev.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> On Oct 9, 2023, at 8:18 AM, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> wrote:
>
> 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?
DISCARD ALL is simply the last query executed. There is no time period for it to "go away". It is the last query executed on that connection, and will remain the last query executed on that connection until another query is executed on that connection.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar | 2023-10-09 14:22:55 | Re: Discard All in pgbouncer |
| Previous Message | Rajesh Kumar | 2023-10-09 14:18:39 | Re: Discard All in pgbouncer |