On Mon, Aug 13, 2018 at 4:04 PM, Don Seiler <d...@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
