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

Re: checkpoint_timeout

From: "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>
To: "Julio Leyva" <jcleyva(at)hotmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: checkpoint_timeout
Date: 2008-10-08 16:34:05
Message-ID: 3a0028490810080934l211d137uc9dde69cad7879d9@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
The wal_buffers is 64Kb (The default)...What Does wal_buffers do?

2008/10/8 Julio Leyva <jcleyva(at)hotmail(dot)com>

> well it depends , our D.B is really high in transactions, and
> checkpoints_segments along with the wal_buffers are ok. you need to play
> with both of them
>
>
>
>
>
>
> ------------------------------
> Date: Wed, 8 Oct 2008 14:19:37 -0200
> From: rafael(dot)domiciano(at)gmail(dot)com
> To: jcleyva(at)hotmail(dot)com
> Subject: Re: [ADMIN] checkpoint_timeout
> CC: bnichols(at)ca(dot)afilias(dot)info; chirag(dot)dave(at)gmail(dot)com;
> pgsql-admin(at)postgresql(dot)org
>
>
> Hello Julio,
> If I set my postgresql server to checkpoint_segments = 10 aren't going to
> be poor segments?
>
>
> 2008/10/8 Julio Leyva <jcleyva(at)hotmail(dot)com>
>
> We have a transactional D.B writing directly to postgres (8.3) and these
> parameters have worked ok for us
>
>
> checkpoint_timeout = 5min
> checkpoint_segments = 10
> wal_buffers = 1024kB
>
>
>
> ------------------------------
> Date: Wed, 8 Oct 2008 12:34:00 -0200
> From: rafael(dot)domiciano(at)gmail(dot)com
> To: bnichols(at)ca(dot)afilias(dot)info
> Subject: Re: [ADMIN] checkpoint_timeout
> CC: chirag(dot)dave(at)gmail(dot)com; pgsql-admin(at)postgresql(dot)org
>
>
> 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.
>
>
>
>

In response to

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2008-10-08 16:46:39
Subject: Re: checkpoint_timeout
Previous:From: Rafael DomicianoDate: 2008-10-08 16:19:37
Subject: Re: checkpoint_timeout

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