On Fri, Jul 31, 2009 at 12:24 AM, Costin Grigoras<cost...@gmail.com> wrote: > >> Anytime autovacuum is instrusive look at incrementing the nap time to >> 10 to 20 ms. If that doesn't help then you're already running on the >> ragged edge of IO throughput and might need to look into a faster RAID >> array or something. >> > > => show autovacuum_naptime; > autovacuum_naptime > -------------------- > 100h
Dangit, I meant cost delay... urg. That's a really long naptime, but since you vacuum anyway it shouldn't matter. So, after disabling autovacuum in postgresql.conf, you reloaded / restart postgresql, right? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
