Re: [Slony1-general] WAL partition overloaded--by autovacuum?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Yen <richyen(at)iparadigms(dot)com>
Cc: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Date: 2010-07-08 19:50:33
Message-ID: 784.1278618633@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David Boreham 2010-07-08 19:50:52 Re: performance on new linux box
Previous Message Kevin Grittner 2010-07-08 19:50:27 Re: [Slony1-general] WAL partition overloaded--by autovacuum?