Checkpoint segments too small

From: Henrik Zagerholm <henke(at)mac(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Checkpoint segments too small
Date: 2007-08-06 09:26:18
Message-ID: CFEA46A7-AE36-4CAF-940E-D76654DA620B@mac.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2007-08-06 10:34:24 Re: Checkpoint segments too small
Previous Message Oleg Bartunov 2007-08-06 07:37:53 Re: Dealing with tsvector in fuctions for data split