On Jul 8, 2010, at 12:50 PM, Tom Lane wrote:
> Richard Yen <richyen@iparadigms.com> writes:
>> My concern is that--as in the original post--there were moments where 129 WAL files were generated in one minute.
Isit plausible that this autovacuum could be responsible for this?
>
> That's not a particularly surprising WAL creation rate for a busy
> database. I wouldn't expect autovacuum to cause it by itself, but
> that's true only because autovacuum processing is typically throttled
> by autovacuum_vacuum_cost_delay. Perhaps you had that set to zero?
>
Ah, yes, autovacuum_vacuum_cost_delay = 0 in my config. That explains it--guess I'm playing with knives if I set
thingsthat way...
--Richard