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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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