Re: Vacuum process waiting on BufferPin

On Mon, Aug 13, 2018 at 4:04 PM, Don Seiler <don(at)seiler(dot)us> wrote:
>
>
> Anyway, my next step is getting the OK to terminate those idle in
> transaction sessions to see if that gets my vacuum job moving. Meanwhile
> I'll ask a dev to sort out why they might be sitting idle in transaction,
> there's no reason for them to be unless the app server connection died and
> they are zombies. However I'm curious if there is someplace else I
> could/should also look to get to the root cause of this.
>

FYI, killing those idle-in-transaction sessions did free up the vacuum job,
which then finished almost immediately afterward.

Don.

--
Don Seiler
www.seiler.us