Re: [Slony1-general] WAL partition overloaded--by autovacuum? - Mailing list pgsql-performance

From Tom Lane
Subject Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Date
Msg-id 784.1278618633@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen <richyen@iparadigms.com>)
Responses Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen <richyen@iparadigms.com>)
List pgsql-performance
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.  Is
itplausible 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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Next
From: David Boreham
Date:
Subject: Re: performance on new linux box