checkpoints are occurring too frequently

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: checkpoints are occurring too frequently
Date: 2011-11-17 12:48:10
Message-ID: 004e01cca527$30fd3570$92f7a050$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a lot of entries like this in the log file

2011-11-17 02:02:46 PYST LOG: checkpoints are occurring too frequently (13
seconds apart)

2011-11-17 02:02:46 PYST HINT: Consider increasing the configuration
parameter "checkpoint_segments".

No, checkpoint parameters in postgres.conf are:

checkpoint_segments = 32 # in logfile segments, min
1, 16MB each

checkpoint_timeout = 10min # range 30s-1h

checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 -
1.0

What should be a correct value for checkpoint_segments to avoid excessive
checkpoint events?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Schubert, Joerg 2011-11-17 12:52:07 synchronous replication + fsync=off?
Previous Message hubert depesz lubaczewski 2011-11-17 12:28:24 Re: how could duplicate pkey exist in psql?