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

Re: checkpoint_timeout

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Julio Leyva <jcleyva(at)hotmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: checkpoint_timeout
Date: 2008-10-09 15:06:02
Message-ID: 1223564762.6070.14.camel@bnicholson-desktop (view raw or flat)
Thread:
Lists: 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.


In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2008-10-09 16:08:07
Subject: Re: PLSQL function calling another function
Previous:From: Rafael DomicianoDate: 2008-10-09 15:02:57
Subject: Re: checkpoint_timeout

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