From: matt@ymogen.net
To: josh@agliodbs.com
Cc: Subbiah, Stalin <ssubbiah@netopia.com>
Cc: 'Andrew Sullivan' <ajs@crankycanuck.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux
Date: Tue, 23 Mar 2004 20:53:42 -0000 (GMT)
Message-ID: <1356.82.68.132.233.1080075222.squirrel@webmail.ymogen.com> (raw)
In-Reply-To: <200403231213.29342.josh@agliodbs.com>
References: <OAEAKHEHCMLBLIDGAFELEEICFBAA.matt@ymogen.net>
<200403231213.29342.josh@agliodbs.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: matt@ymogen.net, josh@agliodbs.com, ssubbiah@netopia.com, ajs@crankycanuck.ca
Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux
In-Reply-To: <1356.82.68.132.233.1080075222.squirrel@webmail.ymogen.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox