Re: Vacuum process waiting on BufferPin

On Tue, Aug 14, 2018 at 9:21 AM, Don Seiler <don(at)seiler(dot)us> wrote:

> On Mon, Aug 13, 2018 at 5:55 PM, Vick Khera <vivek(at)khera(dot)org> wrote:
>
>> On Mon, Aug 13, 2018 at 5:19 PM, Don Seiler <don(at)seiler(dot)us> wrote:
>>
>>>
>>> I don't quite follow this. What circumstances would lead to this
>>> situation?
>>>
>>
>> BEGIN WORK;
>> DECLARE CURSOR ... ;
>> FETCH ...; -- for some number of fetches, which does not reach the end
>> of the cursor.
>>
>> then just sit there idle, without having closed the cursor or fetching
>> anything more.
>>
>
> So the fix in that case would be to ensure that they CLOSE the cursors
> when done with them?
>
>
The general fix is to never sit idle in transaction, but this specific case
closing the cursor seems like it will also do it.