Re: WAL Archiving frequency

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL Archiving frequency
Date: 2006-04-01 20:10:08
Message-ID: 200604011210.08126@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On March 31, 2006 10:39 pm, Brendan Duddridge <brendan(at)clickspace(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brendan Duddridge 2006-04-01 22:26:42 Re: PostgreSQL makes me lie
Previous Message Nirmalya Lahiri 2006-04-01 15:08:52 Re: encryption/decryption