Re: URGENT: Performance tuning - Mailing list pgsql-general

From Curt Sampson
Subject Re: URGENT: Performance tuning
Date
Msg-id Pine.NEB.4.43.0206231444550.542-100000@angelic.cynic.net
Whole thread Raw
In response to Re: URGENT: Performance tuning  (Peter Dimov <jquest_j@yahoo.com>)
Responses Re: URGENT: Performance tuning
List pgsql-general
On Sat, 22 Jun 2002, Peter Dimov wrote:

> First I tested with P II 400 MHz 256 MB RAM.
> And second Dual Athlon MP , 1.6 GHz , 1 or 2 GB RAM.
> I expected to get big advantage from the second system and
> was very supprise from the results : I wan only 30 - 40% faster as the first.

Well, did you analyze your load carefully? How much of your
application is CPU-bound, and how much is disk I/O bound? How much
memory do you need to cache the working set, if it can be cached
at all?

Disks are often very important for database work, far more so than
CPU or memory. I have an application with queries that run about
the same on a 600 MHz Pentium III and a dual 2 GHz Xeon system, if
you use the same disks.

> I think the mistake is by tuning....

Very likely.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


pgsql-general by date:

Previous
From: Peter Dimov
Date:
Subject: Re: URGENT: Performance tuning
Next
From: Peter Dimov
Date:
Subject: Re: URGENT: Performance tuning