Re: WAL Archiving frequency - Mailing list pgsql-general

From Alan Hodgson
Subject Re: WAL Archiving frequency
Date
Msg-id 200604011210.08126@hal.medialogik.com
Whole thread Raw
In response to Re: WAL Archiving frequency  (Brendan Duddridge <brendan@clickspace.com>)
List pgsql-general
On March 31, 2006 10:39 pm, Brendan Duddridge <brendan@clickspace.com>
wrote:
> Thanks Tom,
>
> I just didn't know if that was normal or not. I actually saw 4 WAL
> files / minute today. I set checkpoint_segments = 128, so maybe that
> will help.

That's normal, if your database is busy. I get up to 6 a minute during busy
times.  They compress quite well, fortunately.

--
"None are more hopelessly enslaved than those who falsely believe they are
free." -- Johann W. Von Goethe


pgsql-general by date:

Previous
From: Nirmalya Lahiri
Date:
Subject: Re: encryption/decryption
Next
From: Brendan Duddridge
Date:
Subject: Re: PostgreSQL makes me lie