Search Postgresql Archives

Re: Checkpoints are occurring too frequently...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux