From: Brad Nicholson <bnichols@ca.afilias.info>
To: Rafael Domiciano <rafael.domiciano@gmail.com>
Cc: chirag.dave@gmail.com, "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: checkpoint_timeout
Date: Wed, 08 Oct 2008 10:23:00 -0400
Message-ID: <1223475780.6070.10.camel@bnicholson-desktop> (raw)
In-Reply-To: <3a0028490810080531y155edffi7ff7c68b965a834a@mail.gmail.com>
References: <3a0028490810071321j32b4f450m95123d02b9fe6f49@mail.gmail.com>
<f1d4f3170810071413l3bb62167n2fa32a8ab1ec6dc@mail.gmail.com>
<3a0028490810080531y155edffi7ff7c68b965a834a@mail.gmail.com>
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.
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: bnichols@ca.afilias.info, rafael.domiciano@gmail.com
Subject: Re: checkpoint_timeout
In-Reply-To: <1223475780.6070.10.camel@bnicholson-desktop>
* 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