Checkpoint segments too small

Started by Henrik Zagerholmover 18 years ago2 messagesgeneral
Jump to latest
#1Henrik Zagerholm
henke@mac.se

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?

Regards,
Henrik

#2Magnus Hagander
magnus@hagander.net
In reply to: Henrik Zagerholm (#1)
Re: Checkpoint segments too small

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