Search Postgresql Archives

Re: Checkpoint segments too small

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

 



On Mon, Aug 06, 2007 at 11:26:18AM +0200, Henrik Zagerholm wrote:
> Hi list,
> 
> I'm running 8.2.4 and I've started to get these messages and even  
> though I googled for some answers I couldn't find any good info  
> against the 8.2 code base.
> 
> 2007-08-05 04:00:58.815 CEST  LOG:  checkpoints are occurring too  
> frequently (17 seconds apart)
> 2007-08-05 04:00:58.815 CEST  HINT:  Consider increasing the  
> configuration parameter "checkpoint_segments".
> 
> Right now I use the default setting.
> 
> Is there any idea of raising these at all if I can't move them to a  
> separate disk?

Yes. Just make sure you have enough diskspace for them before you do it.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

[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