Re: Need help with postgresql/apache/php optimisation

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Froggy / Froggy Corp(dot)" <froggy(at)froggycorp(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need help with postgresql/apache/php optimisation
Date: 2004-02-18 20:39:28
Message-ID: Pine.LNX.4.33.0402181337160.3215-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 18 Feb 2004, Froggy / Froggy Corp. wrote:

> The problem is that on "fire time", the load go to > 1 and stay long
> time. But with top (i use top -d 1 to have "real" load average) i can
> see that the CPU is more than 50% idling.
>
> For exemple, i have this kind of stat :
>
> 0s - load 1.5 - cpu idling 0%
> 5s - load 1.6 - cpu ilding 50%
> 6s -> 60s - load around 1.2 - cpu idling around 50%-100%

sounds to me like you're starving for bandwidth on your I/O subsystem.
any chance you can get a faster set of drives under it or go with a SCSI
RAID controller with battery backed cache?

also, turning off fsync may increase speed at the cost of data security in
the event of a kernel crash or power failure.

Are you doing a lot of writing or mostly just reading? If mostly reading,
then you might do well with more memory in the machine. 256 meg is kinda
puny. You'd do better with my old PIII750 machine that had 1.5 gig in it
than a celeron with only 256 meg, no matter how fast the celeron.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-02-18 20:46:31 Re: cannot use createlang after removing public schema
Previous Message Froggy / Froggy Corp. 2004-02-18 20:18:37 Need help with postgresql/apache/php optimisation