Re: [ADMIN] Benchmarking postgres on Solaris/Linux - Mailing list pgsql-performance

From matt@ymogen.net
Subject Re: [ADMIN] Benchmarking postgres on Solaris/Linux
Date
Msg-id 1356.82.68.132.233.1080075222.squirrel@webmail.ymogen.com
Whole thread Raw
In response to Re: [ADMIN] Benchmarking postgres on Solaris/Linux  (Josh Berkus <josh@agliodbs.com>)
Responses Re: [ADMIN] Benchmarking postgres on Solaris/Linux
List 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

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux
Next
From: Darcy Buskermolen
Date:
Subject: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!