Re: Vacuum process waiting on BufferPin

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: Vacuum process waiting on BufferPin
Дата
Msg-id CALd+dccyrP=8OQBEck8xdbFLBBCVALNSZ5M5eJx8V14pPU=xFg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Vacuum process waiting on BufferPin  (Don Seiler <don@seiler.us>)
Ответы Re: Vacuum process waiting on BufferPin  (Don Seiler <don@seiler.us>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Don Seiler
Дата:
Сообщение: Re: Vacuum process waiting on BufferPin
Следующее
От: "David Favro"
Дата:
Сообщение: 'Identifier' columns