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: | Raw Message | Whole Thread | 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 |