From: Greg Smith <gsmith@gregsmith.com>
To: pgsql-performance@postgresql.org
Subject: Re: dell versus hp
Date: Fri, 9 Nov 2007 13:03:20 -0500 (EST)
Message-ID: <Pine.GSO.4.64.0711091204580.19753@westnet.com> (raw)
In-Reply-To: <dcc563d10711090855j42ce308co1bbbe103ff04c706@mail.gmail.com>
References: <82607932-FC46-4B73-BF78-2290EE55F7F5@pvv.ntnu.no>
<47348444.6000700@easyflex.nl>
<b41c75520711090840n31114fa8ldf2eb1bd31161205@mail.gmail.com>
<dcc563d10711090855j42ce308co1bbbe103ff04c706@mail.gmail.com>
On Fri, 9 Nov 2007, Scott Marlowe wrote:
>> Not atm. Until new benchmarks are published comparing AMD's new
>> quad-core with Intel's ditto, Intel has the edge.
>> http://tweakers.net/reviews/657/6
>
> For 8 cores, it appears AMD has the lead, read this (stolen from
> another thread):
> http://people.freebsd.org/~kris/scaling/7.0%20Preview.pdf
This issue isn't simple, and it may be the case that both conclusions are
correct in their domain but testing slightly different things. The
sysbench test used by the FreeBSD benchmark is a much simpler than what
the tweakers.net benchmark simulates.
Current generation AMD and Intel processors are pretty close in
performance, but guessing which will work better involves a complicated
mix of both CPU and memory issues. AMD's NUMA architecture does some
things better, and Intel's memory access takes a second hit in designs
that use FB-DIMMs. But Intel has enough of an advantage on actual CPU
performance and CPU caching that current designs are usually faster
regardless.
For an interesting look at the low-level details here, the current
mainstream parts are compared at http://techreport.com/articles.x/11443/13
and a similar comparison for the just released quad-core Opterons is at
http://techreport.com/articles.x/13176/12
Nowadays Intel vs. AMD is tight enough that I don't even worry about that
part in the context of a database application (there was still a moderate
gap when the Tweakers results were produced a year ago). On a real
server, I'd suggest being more worried about how good the disk controller
is, what the expansion options are there, and relative $/core. In the
x86/x64 realm, I don't feel CPU architecture is a huge issue right now
when you're running a database.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com
Subject: Re: dell versus hp
In-Reply-To: <Pine.GSO.4.64.0711091204580.19753@westnet.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