Re: Vacuum process waiting on BufferPin

Поиск

Список

Период

Сортировка

От	Don Seiler
Тема	Re: Vacuum process waiting on BufferPin
Дата	14 августа 2018 г. 03:19:42
Msg-id	CAHJZqBA5fhYScUba3G6YFoL_A2AxnDzUv9HDG3UQ-JpLbddOhw@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Vacuum process waiting on BufferPin (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы	Re: Vacuum process waiting on BufferPin (Vick Khera <vivek@khera.org>)
Список	pgsql-general

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?

For what its worth, these sessions are backend reporting jobs, not user interfacing at all.

Don.

В списке pgsql-general по дате отправления:

От: Alvaro Herrera
Дата: 14 августа 2018 г., 03:15:06
Сообщение: Re: Vacuum process waiting on BufferPin

От: Don Seiler
Дата: 14 августа 2018 г., 03:26:50
Сообщение: Re: Vacuum process waiting on BufferPin