Re: set autovacuum=off

On Thu, Feb 23, 2012 at 10:38 AM, Alessandro Gagliardi
<alessandro@path.com> wrote:
> On Thu, Feb 23, 2012 at 10:01 AM, Steve Crawford
> <scrawford@pinpointresearch.com> wrote:
> So if it's not auto-vacuuming that's making my inserts so slow, what is it?
> I'm batching my inserts (that didn't seem to help at all actually, but maybe
> cause I had already turned off synchronous_commit anyway). I've gotten rid
> of a bunch of indices (especially those with low cardinality–that I did
> 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