Re: [GENERAL] Performance - Mailing list pgsql-general

From The Hermit Hacker
Subject Re: [GENERAL] Performance
Date
Msg-id Pine.BSF.4.05.9903301001080.55565-100000@thelab.hub.org
Whole thread Raw
In response to Performance  (Jason <neumeier@bright.net>)
Responses Re: [GENERAL] Performance
Re: [GENERAL] Performance
List pgsql-general
Starting several months back, at work, I've been pushing our Unix
department away from Sparcs and onto Intel servers (IBM Netfinity)...the
main reason being cost/performance just isn't there for the Sparcs.  never
was, but the Intel servers, until recently, haven't been the most stable
to run off of.

Using the rc5 client as a 'benchmark' (what else has programmers working
hard to optimize their code to get the best numbers on it?), we found that
when comparing a Dual-PII 450 against an Sparc E450/400Mhz, the E450 came
in at ~30% less powerful then the Dual-PII ...

If you take a look at http://infopad.EECS.Berkeley.EDU/CIC/summary/local,
it shows comparisons of the various CPUs out there, up until Nov/98 ...
the Intel CPUs blow away the Sparc chip's in integer arithmetic, while the
Sparc excels in floating point.  Your operating system, and the database,
tends to do most stuff in integer, so you get performance boons that
way...

The other thing to consider is that you are comparing two differences, not
just one.  Different CPUs and different operating systems.  Solaris isn't
nicknamed 'slowaris' for nothing :)  Its a bloated OS, albeit stable...

On Tue, 30 Mar 1999, Jason wrote:

> Looking for a little reasoning behind our performance difference on 2
> different platforms.  We have been running postgres on our sparcs, and
> have come to rely on the dB quite heavily.  We have dedicated a box to
> doing nothing but our postgres work.  Here is what we have:
>
> Dual Sparc 167
> 512 MB RAM
> Solaris 2.5.1
>
> Performance seemed reasonable to us, until we ran the same database and
> queries on the following machine:
>
> Intel Celeron 333
> 128 MB RAM
> Red Hat Linux 5.2
>
> We have a passwd style database with 65,000 rows.  We updated 20,000 of
> them with a SQL update command, setting a single integer field to a
> value.  Both boxes where indexed the same, and had identical data.  The
> Sparc took near 10 minutes to complete, while the Intel took ~30
> seconds.  This is just one case, but many very similar tests had the
> same results.
>
> Now I love Linux, and the price compared to a Sparc makes it much
> simpler to get one on line.  However, I can't understand why the Sparc
> would lag so far behind.  We are starting Postgres the same on both
> machines:
>
> su - postgres -c "/usr/local/pgsql/bin/postmaster -B 256 -o -F -i -S"
>
> We are looking at getting a dual 400 Intel Pentium II box with Red Hat
> to migrate all of the Postgres work to.  But in the meantime, is there a
> way to optimize the performance on the Sparc?  Thanks in advance.
>
> -Jason Neumeier.
>
>
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


pgsql-general by date:

Previous
From: Kollar Lajos
Date:
Subject: Re: [GENERAL] sorting by date & time in descending order ??
Next
From: Statistical Solutions
Date:
Subject: Re: [GENERAL] Performance