Re: BUG #5759: Autovacuum cost limit trends to 1, using default config

"Simon Poole" <postgresql@simon.themalago.net> writes:
> With the default autovacuum settings (3 workers, and default cost_limit of
> 200), all three workers start with a cost-limit of 66 each, but after each
> table is completed, the cost-limit is reduced until they're all running with
> a cost-limit of 1.

Yeah, I was able to reproduce this, more or less.  It looks like the
problem is that the cost rebalancing algorithm uses VacuumCostLimit
as an input, and supposes that's constant ... but after the first table
it's actually been reduced by a previous iteration (assuming there's
more than one worker).  So you can end up computing a smaller value
on the next round.  Lather, rinse, repeat.

Will fix.  Thanks for the report!

            regards, tom lane