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

From Don Seiler
Subject Re: Vacuum process waiting on BufferPin
Date
Msg-id CAHJZqBC6NQEExzBYJ9EvXwkxpVikzYU9YrrU3gA04fen5RwA_A@mail.gmail.com
Whole thread Raw
In response to Vacuum process waiting on BufferPin  (Don Seiler <don@seiler.us>)
List pgsql-general
On Mon, Aug 13, 2018 at 4:04 PM, Don Seiler <don@seiler.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

pgsql-general by date:

Previous
From: Don Seiler
Date:
Subject: Re: Vacuum process waiting on BufferPin
Next
From: Vick Khera
Date:
Subject: Re: Vacuum process waiting on BufferPin