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

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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Richard Yen" <richyen(at)iparadigms(dot)com>
Cc: "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:27
Message-ID: 4C35E5B30200002500033284@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
Richard Yen <richyen(at)iparadigms(dot)com> wrote:
 
> there were moments where 129 WAL files were generated in one
> minute.  Is it plausible that this autovacuum could be responsible
> for this?
 
I don't remember seeing your autovacuum and vacuum config settings,
or an answer to my question about whether there was a bulk load of a
significant portion of current data.  With agressive autovacuum
settings, hitting the freeze threshold for bulk-loaded data could do
that.
 
-Kevin

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2010-07-08 19:50:33
Subject: Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Previous:From: Ryan WexlerDate: 2010-07-08 19:47:52
Subject: Re: performance on new linux box

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