Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group