Tom Lane wrote: > Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes: > > Also if autovacuum is eating all your I/O you may want to look into > > throttling it back a bit by setting autovacuum_vacuum_cost_delay to a > > non-zero value. > > BTW, why is it that autovacuum_cost_delay isn't enabled by default? > I can hardly believe that anyone will want to run it without that. > *Especially* not with multiple workers configured by default. Just because we haven't agreed a value. Default autovacuum parameters is something we should definitely discuss for 8.3. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support