Re: multiple apaches against single postgres database

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Honza Novak" <kacerr(at)developers(dot)zlutazimnice(dot)cz>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: multiple apaches against single postgres database
Date: 2007-10-24 17:22:35
Message-ID: 471F390A.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>> On Wed, Oct 24, 2007 at 7:15 AM, in message
<471F3752(dot)8070205(at)developers(dot)zlutazimnice(dot)cz>, Honza Novak
<kacerr(at)developers(dot)zlutazimnice(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tatsuo Ishii 2007-10-25 03:26:53 Re: multiple apaches against single postgres database
Previous Message Sven Geisler 2007-10-24 14:33:10 Re: multiple apaches against single postgres database