"Ed L." <pgsql@xxxxxxxxxxxxx> writes: > On Tuesday November 14 2006 12:56 pm, Jim C. Nasby wrote: >> You don't have the vacuum cost delay settings set unreasonably >> high, do you? > I'm not sure. Here's what we're running: > autovacuum_vacuum_cost_delay = 500 # default vacuum cost delay for > # vacuum_cost_delay > autovacuum_vacuum_cost_limit = 200 # default vacuum cost limit for > # vacuum_cost_limit That's unreasonably high --- you're telling autovac to do a little work (about ten pages' worth) and then sleep for half a second. No wonder it seems to take forever on a big table. Try autovacuum_vacuum_cost_delay around 10 or 20 (msec) or so. regards, tom lane
