From: William Yu <wyu@talisys.com>
To: pgsql-performance@postgresql.org
Subject: Re: Large (8M) cache vs. dual-core CPUs
Date: Wed, 26 Apr 2006 07:19:38 -0700
Message-ID: <e2nvhj$1h3b$1@news.hub.org> (raw)
In-Reply-To: <20060426011701.GB12711@mark.mielke.cc>
References: <20060425141435.6c8c163c.wmoran@collaborativefusion.com>
<1145990018.23538.234.camel@state.g2switchworks.com>
<20060425183817.GA9241@mark.mielke.cc>
<1145990551.23538.244.camel@state.g2switchworks.com>
<20060426005440.GA12711@mark.mielke.cc>
<20060426011701.GB12711@mark.mielke.cc>
mark@mark.mielke.cc wrote:
>
> I have an Intel Pentium D 920, and an AMD X2 3800+. These are very
> close in performance. The retail price difference is:
>
> Intel Pentium D 920 is selling for $310 CDN
> AMD X2 3800+ is selling for $347 CDN
>
> Anybody who claims that Intel is 2X more expensive for the same
> performance, isn't considering all factors. No question at all - the
> Opteron is good, and the Xeon isn't - but the original poster didn't
> ask about Opeteron or Xeon, did he? For the desktop lines - X2 is not
> double Pentium D. Maybe 10%. Maybe not at all. Especially now that
> Intel is dropping it's prices due to overstock.
There's part of the equation you are missing here. This is a PostgreSQL
mailing list which means we're usually talking about performance of just
this specific server app. While in general there may not be that much of
a % difference between the 2 chips, there's a huge gap in Postgres. For
whatever reason, Postgres likes Opterons. Way more than Intel
P4-architecture chips. (And it appears way more than IBM Power4 chips
and a host of other chips also.)
Here's one of the many discussions we had about this issue last year:
http://qaix.com/postgresql-database-development/337-670-re-opteron-vs-xeon-was-what-to-do-with-6-dis...
The exact reasons why Opteron runs PostgreSQL so much better than P4s,
we're not 100% sure of. We have guesses -- lower memory latency, lack of
shared FSB, better 64-bit, 64-bit IOMMU, context-switch storms on P4,
better dualcore implementation and so on. Perhaps it's a combination of
all the above factors but somehow, the general experience people have
had is that equivalently priced Opterons servers run PostgreSQL 2X
faster than P4 servers as the baseline and the gap increases as you add
more sockets and more cores.
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: wyu@talisys.com
Subject: Re: Large (8M) cache vs. dual-core CPUs
In-Reply-To: <e2nvhj$1h3b$1@news.hub.org>
* 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