Re: Checkpoints are occurring too frequently... - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Checkpoints are occurring too frequently...
Date
Msg-id 1121191522.8208.231.camel@state.g2switchworks.com
Whole thread Raw
In response to Checkpoints are occurring too frequently...  ("Greg Patnude" <gpatnude@hotmail.com>)
List pgsql-general
On Tue, 2005-07-12 at 13:04, Greg Patnude wrote:
> 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 ???

Lots of updates or inserts.

What are you doing with your database?  Are you running some application
that is doing a lot of small inserts maybe?

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Windows version of PostgreSQL 8.x?
Next
From: Tony Caduto
Date:
Subject: Re: Windows version of PostgreSQL 8.x?