| From: | Don Seiler <don(at)seiler(dot)us> |
|---|---|
| To: | Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com> |
| Cc: | Vick Khera <vivek(at)khera(dot)org>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Vacuum process waiting on BufferPin |
| Date: | 2018-08-14 14:11:43 |
| Message-ID: | CAHJZqBByacQJ3_bjbABNxWikJxMZ7SG+SUDtGBO2nCbtRKFROQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Aug 14, 2018 at 8:58 AM, Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>
wrote:
>
> There is an idle_in_transaction_session_timeout parameter to kill
> connections that are idle (in transaction) for too long. It was
> implemented specifically for cases like this.
Thanks for reminding me of this. I'll probably look to set it but make sure
to point out that it is just a safety net to let DB maintenance run and
they should make sure their work is committed cleanly if they want to keep
it.
Don.
--
Don Seiler
www.seiler.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Cardwell | 2018-08-14 14:18:24 | pg_basebackup failed to read a file |
| Previous Message | Adrian Klaver | 2018-08-14 14:04:31 | Re: Copying data from a CSV file into a table dynamically |