Re: server gets slow at certain time

From: Thom Brown <thom(at)linux(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: server gets slow at certain time
Date: 2010-10-29 13:38:38
Message-ID: AANLkTinaLW26Q0WOKAqGMJJtstswGML=4GnLnxor-Zfz@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 29 October 2010 14:34, AI Rumman <rummandba(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Balažic 2010-10-29 13:40:57 9.0.1-1 windows install VC++ 2008 redistributalbe warning
Previous Message AI Rumman 2010-10-29 13:34:37 Re: server gets slow at certain time