Re: checkpoint_timeout

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.