Re: set autovacuum=off

[Alessandro Gagliardi <alessandro@xxxxxxxx>]

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 <pvh@xxxxxx> wrote:

On Thu, Feb 23, 2012 at 10:38 AM, Alessandro Gagliardi
<alessandro@xxxxxxxx> 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