| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Henrik Zagerholm <henke(at)mac(dot)se> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Checkpoint segments too small |
| Date: | 2007-08-06 10:34:24 |
| Message-ID: | 20070806103424.GD24616@svr2.hagander.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Aug 06, 2007 at 11:26:18AM +0200, Henrik Zagerholm wrote:
> Hi list,
>
> I'm running 8.2.4 and I've started to get these messages and even
> though I googled for some answers I couldn't find any good info
> against the 8.2 code base.
>
> 2007-08-05 04:00:58.815 CEST LOG: checkpoints are occurring too
> frequently (17 seconds apart)
> 2007-08-05 04:00:58.815 CEST HINT: Consider increasing the
> configuration parameter "checkpoint_segments".
>
> Right now I use the default setting.
>
> Is there any idea of raising these at all if I can't move them to a
> separate disk?
Yes. Just make sure you have enough diskspace for them before you do it.
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alain Roger | 2007-08-06 10:37:00 | import content of XLS file into PostgreSQL |
| Previous Message | Henrik Zagerholm | 2007-08-06 09:26:18 | Checkpoint segments too small |