On Sun, Dec 14, 2008 at 11:27 AM, Michael Monnerie <michael.monnerie@xxxxxxxxxxxxxxxxxxx> wrote: > On Samstag 13 Dezember 2008 Matthew T. O'Connor wrote: >> Do you have any vacuum delay setting turned on? Perhaps they are too >> high? > > Oh, I didn't remember there were some for normal vacuum, just the > auto_vaccuum. > > 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
