I'm unable to make sense of pg_locks. The vast majority are locktype='transactionid', mode='ExclusiveLock', granted=t. There are some 'relation' locks with mode='RowExclusiveLock' and fewer with 'AccessShareLock'. I have no idea what I should be looking for here.
On Thu, Feb 23, 2012 at 10:42 AM, Peter van Hardenberg <p...@pvh.ca> wrote: > On Thu, Feb 23, 2012 at 10:38 AM, Alessandro Gagliardi > <alessan...@path.com> wrote: > > around the same time as disabling auto-vacuum, so that could account for > the > > coincidental speed up). I'm not sure what else I could be doing wrong. > It's > > definitely better than it was a few days ago, but I still see "LOG: > > duration: 77.315 ms statement: COMMIT" every minute or two. > > > > Have you considered that you may have lock contention? Sampling > pg_locks may be illuminating; based on your description the lock > contention would be intermittent, so I wouldn't trust an n=1 test. > > -p > > -- > Peter van Hardenberg > San Francisco, California > "Everything was beautiful, and nothing hurt." -- Kurt Vonnegut >
