From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Julio Leyva <jcleyva@hotmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: checkpoint_timeout
Date: Thu, 9 Oct 2008 13:02:57 -0200
Message-ID: <3a0028490810090802t9294abeod6e5ece092a487e4@mail.gmail.com> (raw)
In-Reply-To: <dcc563d10810081116g6aece154rbadf99951ab4caa2@mail.gmail.com>
References: <3a0028490810071321j32b4f450m95123d02b9fe6f49@mail.gmail.com>
<3a0028490810080734r26912c72n94d6f509dfb55b6e@mail.gmail.com>
<BLU102-W53021316E8139B5A348338A13B0@phx.gbl>
<3a0028490810080919v3762f924je688a56210558e95@mail.gmail.com>
<BLU102-W420C4D08216238B5121B32A13B0@phx.gbl>
<3a0028490810080934l211d137uc9dde69cad7879d9@mail.gmail.com>
<48EC9D9F.EE98.0025.0@wicourts.gov>
<3a0028490810081054o2100b2bci7bde6b7213712c58@mail.gmail.com>
<48ECB0DD.EE98.0025.0@wicourts.gov>
<dcc563d10810081116g6aece154rbadf99951ab4caa2@mail.gmail.com>
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
2008/10/8 Scott Marlowe <scott.marlowe@gmail.com>
> On Wed, Oct 8, 2008 at 12:08 PM, Kevin Grittner
> <Kevin.Grittner@wicourts.gov> wrote:
> >
> > If the problem is checkpoints (which seems likely but far from a sure
> > thing based on the information provided), aggressive background writer
> > setting might be your best bet under 8.2.X. To solve similar problems
> > we had to go to the following, although many on these lists feel that
> > settings this aggressive are rarely needed, so use at your own risk.
> >
> > #bgwriter_delay = 200ms
> > bgwriter_lru_percent = 20.0
> > bgwriter_lru_maxpages = 200
> > bgwriter_all_percent = 10.0
> > bgwriter_all_maxpages = 600
>
> I've tuned an 8.2 server with settings similar to this, and it made a
> world of difference on smoothing out performance. Note that bgwriter
> tends to use cpu and memory bandwidth up, so avoid going crazy on it.
>
> > Even better would be to go to the latest revision of the 8.3 release,
> > which at this writing is 8.3.4. In that release PostgreSQL spreads
> > out the work of a checkpoint to minimize this problem.
>
> Seconded. A lot of hard work went into making the bgwriter much
> easier to adjust, and much less likely to even need adjusting in 8.3.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rafael.domiciano@gmail.com, scott.marlowe@gmail.com, Kevin.Grittner@wicourts.gov, jcleyva@hotmail.com
Subject: Re: checkpoint_timeout
In-Reply-To: <3a0028490810090802t9294abeod6e5ece092a487e4@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox