Re: checkpoint_timeout - Mailing list pgsql-admin

From Brad Nicholson
Subject Re: checkpoint_timeout
Date
Msg-id 1223564762.6070.14.camel@bnicholson-desktop
Whole thread Raw
In response to Re: checkpoint_timeout  ("Rafael Domiciano" <rafael.domiciano@gmail.com>)
List pgsql-admin
On Thu, 2008-10-09 at 13:02 -0200, Rafael Domiciano wrote:
> Hi there.
>
>
> I increased the wal_buffers and no change made.
> I'm beggining to think that my problem is not related to "checkpoint &
> cia" as I said early.
> I have decreased the checkpoint_timeout to 3 min and the slow down
> continuin' ocorring after each 5 min.
>
>
> In this "slowdown" the postgres does nothing, it's simply stop doing
> the operations. The softwares still waiting for the response.
> This is a dedicated server, the only program another postgres that
> runs is Slony-I

This sounds like checkpoint issues to me.  Try adjusting the bgwriter
settings as suggested.

--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.


pgsql-admin by date:

Previous
From: "Rafael Domiciano"
Date:
Subject: Re: checkpoint_timeout
Next
From: Carol Walter
Date:
Subject: errors in gmake...