pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (22+ messages)  latest in thread

Message-ID: <1356.82.68.132.233.1080075222.squirrel@webmail.ymogen.com>
Permalink:  ../1356.82.68.132.233.1080075222.squirrel@webmail.ymogen.com/
Also on:    postgresql.org/message-id/1356.82.68.132.233.1080075222.squirrel@webmail.ymogen.com

 · 

reply

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