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.