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: "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Richard Yen" <richyen(at)iparadigms(dot)com>
Cc: "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:04:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> I don't understand how you managed to fill up 37GB of disk with
> WAL files.  Every time you fill up checkpoint_segments * 16MB of
> WAL files, you ought to get a checkpoint.  When it's complete, WAL
> segments completely written before the start of the checkpoint
> should be recyclable.  Unless I'm confused, which apparently I am.
You're not alone.  At first I was assuming that it was because of
archiving, but the OP says that's turned off.  Unless it had been on
and there wasn't a *restart* after changing the configuration, I
can't see how this could happen, and was hoping someone else could
cast some light on the issue.
The one setting that gave me pause was:
but it doesn't seem like that should matter with:

In response to


pgsql-performance by date

Next:From: Jochen ErwiedDate: 2010-07-08 19:13:51
Subject: Re: performance on new linux box
Previous:From: Robert HaasDate: 2010-07-08 18:51:04
Subject: Re: [Slony1-general] WAL partition overloaded--by autovacuum?

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