Thread: Getting Slow
View Single Post

   
  #6 (permalink)  
Old 04-19-2008, 09:57 AM
Tom Lane
 
Posts: n/a
Default Re: Getting Slow

Alvaro Herrera <alvherre@commandprompt.com> 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.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote