On Thu, Feb 23, 2012 at 10:38 AM, Alessandro Gagliardi <alessandro@xxxxxxxx> wrote: > On Thu, Feb 23, 2012 at 10:01 AM, Steve Crawford > <scrawford@xxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
