Checkpoints are occurring too frequently...

From: "Greg Patnude" <gpatnude(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Checkpoints are occurring too frequently...
Date: 2005-07-12 18:04:31
Message-ID: db10ai$u3o$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

LOG: checkpoints are occurring too frequently (19 seconds apart)
HINT: Consider increasing the configuration parameter
"checkpoint_segments".
LOG: checkpoints are occurring too frequently (12 seconds apart)
HINT: Consider increasing the configuration parameter
"checkpoint_segments".
LOG: checkpoints are occurring too frequently (12 seconds apart)
HINT: Consider increasing the configuration parameter
"checkpoint_segments".
LOG: checkpoints are occurring too frequently (11 seconds apart)
HINT: Consider increasing the configuration parameter
"checkpoint_segments".
LOG: checkpoints are occurring too frequently (12 seconds apart)
HINT: Consider increasing the configuration parameter
"checkpoint_segments".

What does this mean and what causes it ???

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-07-12 18:05:22 Re: Checkpoints are occurring too frequently...
Previous Message Scott Marlowe 2005-07-12 18:00:25 Re: Windows version of PostgreSQL 8.x?