Skip site navigation (1) Skip section navigation (2)

Re: [ADMIN] Benchmarking postgres on Solaris/Linux

From: matt(at)ymogen(dot)net
To: josh(at)agliodbs(dot)com
Cc: "Subbiah, Stalin" <ssubbiah(at)netopia(dot)com>,"'Andrew Sullivan'" <ajs(at)crankycanuck(dot)ca>,pgsql-performance(at)postgresql(dot)org
Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux
Date: 2004-03-23 20:53:42
Message-ID: 1356.82.68.132.233.1080075222.squirrel@webmail.ymogen.com (view raw or flat)
Thread:
Lists: pgsql-performance
> Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do
> better than you think, comparitively.    On all the Dell servers I've used
> so
> far, I've not seen performance that comes even close to the hardware
> specs.

It's true that any difference will be far less than the GHz ratio, and I
can't really speak for Dell servers in general, but a pair of 2.4GHz Xeons
in a Dell workstation gets about 23 SPECint_rate2000, and a pair of 1GHz
UltraSparc IIIs in a SunFire V210 gets 10.  The ratios are the same for
other non-FP benchmarks.

Now the Suns do have some architectural advantages, and they used to have
far superior memory bandwidth than intel boxes, and they often still do
for more than 2 cpus, and definitely do for more than four.  But my
personal experience is that for 4 cpus or less the entry level UNIX
offerings from Sun/IBM/HP fell behind in raw performance (FP excepted) two
or three years ago.  The posh hardware's an entirely different matter of
course.

On the other hand, I can think of innumerable non performance related
reasons to buy a 'real UNIX box' as a low end DB server.  CPU performance
is way down the priority list compared with IO throughput, stability,
manageability, support, etc etc.

Given that the original question was about a very heavily write-oriented
environment, I'd take the Sun every day of the week, assuming that those
compile option changes have sorted out the oddly slow PG performance at
last.

M

In response to

Responses

pgsql-performance by date

Next:From: Craig ThomasDate: 2004-03-23 21:56:35
Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux
Previous:From: scott.marloweDate: 2004-03-23 20:52:50
Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group