Postgres Pro
Downloads
Home   >   mailing lists

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

From Vick Khera
Subject Re: Vacuum process waiting on BufferPin
Date
Msg-id CALd+dccyrP=8OQBEck8xdbFLBBCVALNSZ5M5eJx8V14pPU=xFg@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum process waiting on BufferPin  (Don Seiler <don@seiler.us>)
Responses Re: Vacuum process waiting on BufferPin
List pgsql-general
Tree view
On Mon, Aug 13, 2018 at 5:19 PM, Don Seiler <don@seiler.us> wrote:
On Mon, Aug 13, 2018 at 4:15 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:

Maybe you had a cursor that was not fully scanned before the session was
left idle -- as I recall, those can leave buffers pinned.  

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.

pgsql-general by date:

Previous
From: Don Seiler
Date:
Subject: Re: Vacuum process waiting on BufferPin
Next
From: "David Favro"
Date:
Subject: 'Identifier' columns