pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Arjen van der Meijden <acmmailing@tweakers.net>
To: jlmarin <jlmarin@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Diminishing bandwidth performance with multiple quad core X5355s
Date: Sun, 20 May 2007 19:13:58 +0200
Message-ID: <465081D6.1080306@tweakers.net> (raw)
In-Reply-To: <1179093615.331448.161490@e65g2000hsc.googlegroups.com>
References: <1178306856.209698.70370@o5g2000hsb.googlegroups.com>
	<4t3n33tp6ps3sqg09gfotgvvs1l9tvhs12@4ax.com>
	<1178351083.414445.314580@w5g2000hsg.googlegroups.com>
	<1179093615.331448.161490@e65g2000hsc.googlegroups.com>

On 14-5-2007 0:00 jlmarin wrote:
> I wanted to post this even if it's a bit late on the thread because
> right now I have exactly this kind of problem.
> We're trying to figure out if a dual-Quadcore (Xeon) will be better
> (cost/benefit wise) than a 4-way Opteron dualcore, for *our* program.

We've benchmarked the Sun Fire x4600 (with the older socket 939 cpu's) 
and compared it to a much cheaper dual quad core xeon X5355.

As you can see on the end of this page:
http://tweakers.net/reviews/674/8

The 4-way dual core opteron performs less (in our benchmark) than the 
2-way quad core xeon. Our benchmark does not consume a lot of memory, 
but I don't know which of the two profits most of that. Obviously it may 
well be that the Socket F opterons with support for DDR2 memory perform 
better, but we haven't seen much proof of that.
Given the cost of a 4-way dual core opteron vs a 2-way quad core xeon, 
I'd go for the latter for now. The savings can be used to build a system 
with heavier I/O and/or more memory, which normally yield bigger gains 
in database land.
For example a Dell 2900 with 2x X5355 + 16GB of memory costs about 7000 
euros less than a Dell 6950 with 4x 8220 + 16GB. You can buy an 
additional MD1000 with 15x 15k rpm disks for that... And I doubt you'll 
find any real-world database benchmark that will favour the 
opteron-system if you look at the price/performance-picture.

Of course this picture might very well change as soon as the new 
'Barcelona' quad core opterons are finally available.

> As you say, Opterons do definitely have a much better memory system.
> But then a 4-way mobo is WAY more expensive that a dual-socket one...

And it might be limited by NUMA and the relatively simple broadcast 
architecture for cache coherency.

Best regards,

Arjen van der Meijden



view thread (2+ messages)

Message-ID: <465081D6.1080306@tweakers.net>
Permalink:  ../465081D6.1080306@tweakers.net/
Also on:    postgresql.org/message-id/465081D6.1080306@tweakers.net

 · 

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: acmmailing@tweakers.net, jlmarin@gmail.com
  Subject: Re: Diminishing bandwidth performance with multiple quad core X5355s
  In-Reply-To: <465081D6.1080306@tweakers.net>

* 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