| From: | Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com> |
|---|---|
| To: | Don Seiler <don(at)seiler(dot)us>, Vick Khera <vivek(at)khera(dot)org> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Vacuum process waiting on BufferPin |
| Date: | 2018-08-14 13:58:59 |
| Message-ID: | 712d9ac9-5c7a-ace4-5030-d282573f89bb@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 14/08/18 15:26, Don Seiler wrote:
> On Tue, Aug 14, 2018 at 8:23 AM, Vick Khera <vivek(at)khera(dot)org
> <mailto:vivek(at)khera(dot)org>> wrote:
>
>
> The general fix is to never sit idle in transaction, but this
> specific case closing the cursor seems like it will also do it.
>
>
> Of course. I've let development know that they need to sort out why it's
> left that way.
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.
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ruiqiang Chen | 2018-08-14 14:01:35 | Re: Copying data from a CSV file into a table dynamically |
| Previous Message | Ron | 2018-08-14 13:46:43 | Re: Copying data from a CSV file into a table dynamically |