Search Postgresql Archives

Re: server gets slow at certain time

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

 



On 29 October 2010 14:34, AI Rumman <rummandba@xxxxxxxxx> wrote:
At present,
checkpoint_segment=3
checkpoint_timeout=300


I'd recommend at least setting checkpoint_segments to 12 and you might want to increase checkpoint_timeout too, although not too high.  Maybe try doubling it.

And as Devrim pointed out, pre-8.3 versions suffer from these problems more, and 8.1 will cease to be supported in the near future, so if you're able to, upgrade. :)

Thom

[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