From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Honza Novak <kacerr@developers.zlutazimnice.cz>
To: pgsql-performance@postgresql.org
Subject: Re: multiple apaches against single postgres database
Date: Wed, 24 Oct 2007 12:22:35 -0500
Message-ID: <471F390A.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <471F3752.8070205@developers.zlutazimnice.cz>
References: <471F3752.8070205@developers.zlutazimnice.cz>
>>> On Wed, Oct 24, 2007 at 7:15 AM, in message
<471F3752.8070205@developers.zlutazimnice.cz>, Honza Novak
<kacerr@developers.zlutazimnice.cz> wrote:
> But sometimes (i don't know exactly for what reason) some queries gets
> stuck (mostly they are inserts or updates, but realy simple) and
> postgres is unable to answer in time
In addition to the points made by others, there is a chance that a
contributing factor is the tendency of PostgreSQL (prior to the
upcoming 8.3 release) to hold onto dirty pages for as long as
possible and throw them all at the disk drives in at checkpoint
time. In some such cases the advice from previous emails may not
be enough -- you may have to use very aggressive background writer
settings, a smaller shared buffers setting, and/or reduce or
eliminate the OS write delays.
If you find this to be your problem, you may want to be an early
adopter of the 8.3 release, once it is out.
-Kevin
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-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, kacerr@developers.zlutazimnice.cz
Subject: Re: multiple apaches against single postgres database
In-Reply-To: <471F390A.EE98.0025.0@wicourts.gov>
* 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