Re: server gets slow at certain time - Mailing list pgsql-general

From Thom Brown
Subject Re: server gets slow at certain time
Date
Msg-id AANLkTinaLW26Q0WOKAqGMJJtstswGML=4GnLnxor-Zfz@mail.gmail.com
Whole thread Raw
In response to Re: server gets slow at certain time  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
On 29 October 2010 14:34, AI Rumman <rummandba@gmail.com> 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

pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Re: server gets slow at certain time
Next
From: David Balažic
Date:
Subject: 9.0.1-1 windows install VC++ 2008 redistributalbe warning