Re: Vacuum process waiting on BufferPin

From: Don Seiler <don(at)seiler(dot)us>
To: 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:21:20
Message-ID: CAHJZqBAON7a9LGxf3gAtptoEG6AngHCwCibZGRBYn6dqsSreJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Don.

--
Don Seiler
www.seiler.us

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2018-08-14 13:23:23 Re: Vacuum process waiting on BufferPin
Previous Message Adrian Klaver 2018-08-14 13:20:11 Re: Copying data from a CSV file into a table dynamically