Re: checkpoint_timeout

Hello Brad,

All of my bgwriter parameters is set on default. Following:#bgwriter_delay =
200ms # 10-10000ms between rounds
#bgwriter_lru_percent = 1.0 # 0-100% of LRU buffers
scanned/round
#bgwriter_lru_maxpages = 5 # 0-1000 buffers max written/round
#bgwriter_all_percent = 0.333 # 0-100% of all buffers
scanned/round
#bgwriter_all_maxpages = 5 # 0-1000 buffers max written/round

I am trying now to increase the checkpoint_segments to 40...

2008/10/8 Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>

> On Wed, 2008-10-08 at 10:31 -0200, Rafael Domiciano wrote:
> > The server is running Postgres 8.2.4
> > When the server is doing too much operations like I, U or D the
> > postgres stop a while each 5 min...!
> > I mean "stopping" that I don't receive any response from postgres, and
> > the process the all people are running stay there, waiting for
> > something.
> > I read a several names to it like: gap, stall, slowdown... I don't
> > know the write expression for this situation.
>
> The bgwriter was added to help alleviate this problem.
>
> What are your settings for that? The solution may be to push dirty
> buffers to disk more aggressively via the bgwriter so you have less work
> to do at checkpoint time.
>
>
> --
> Brad Nicholson 416-673-4106
> Database Administrator, Afilias Canada Corp.
>
>