Re: Checkpoints are occurring too frequently...

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?