Re: Vacuum process waiting on BufferPin

On Mon, Aug 13, 2018 at 5:19 PM, Don Seiler <don@seiler.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.