Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group