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.
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2008-10-09 16:08:07|
|Subject: Re: PLSQL function calling another function |
|Previous:||From: Rafael Domiciano||Date: 2008-10-09 15:02:57|
|Subject: Re: checkpoint_timeout|