Richard Yen <richyen(at)iparadigms(dot)com> writes:
> My concern is that--as in the original post--there were moments where 129 WAL files were generated in one minute. Is it 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?
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: David Boreham||Date: 2010-07-08 19:50:52|
|Subject: Re: performance on new linux box|
|Previous:||From: Kevin Grittner||Date: 2010-07-08 19:50:27|
|Subject: Re: [Slony1-general] WAL partition overloaded--by autovacuum?|