"Ed L." <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
