Re: Vacuum process waiting on BufferPin - Mailing list pgsql-general

From Don Seiler
Subject Re: Vacuum process waiting on BufferPin
Date
Msg-id CAHJZqBD0ecLukUSVcU=waP93Z9nnxVM2+f9SF9L0wnOVM0Xwpw@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum process waiting on BufferPin  (Vick Khera <vivek@khera.org>)
Responses Re: Vacuum process waiting on BufferPin
List pgsql-general
On Tue, Aug 14, 2018 at 8:23 AM, Vick Khera <vivek@khera.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. But if they're also NOT closing cursors, that seems like another bad practice to correct.

Would commit/rollback automatically close cursors opened in that transaction?

Don.

--
Don Seiler
www.seiler.us

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Vacuum process waiting on BufferPin
Next
From: pavan95
Date:
Subject: Re: Copying data from a CSV file into a table dynamically