On Sun, Dec 14, 2008 at 11:27 AM, Michael Monnerie
> On Samstag 13 Dezember 2008 Matthew T. O'Connor wrote:
>> Do you have any vacuum delay setting turned on? Perhaps they are too
> Oh, I didn't remember there were some for normal vacuum, just the
> vacuum_cost_delay = 250
> vacuum_cost_page_hit = 1
> vacuum_cost_page_miss = 10
> vacuum_cost_page_dirty = 20
> vacuum_cost_limit = 1000
> Are those values to high/low? What should one use?
> I think I will disable it at this one server, setting
> vacuum_cost_delay = 0
> because it's only one DB here. Still, I'd like to understand what values
> would be reasonable on a server with many DBs, as we have some.
Yeah, any vacuum cost_delay over 20 or so is pretty high. I set it to
10 and vacuum doesn't get in the way but still runs reasonably fast.
In response to
pgsql-admin by date
|Next:||From: Jaime Casanova||Date: 2008-12-15 21:31:39|
|Subject: Re: Urgente error in restore prod|
|Previous:||From: Michael Monnerie||Date: 2008-12-14 18:27:42|
|Subject: Re: What is VACUUM waiting for?|