From: mark@mark.mielke.cc
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Bill Moran <wmoran@collaborativefusion.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Large (8M) cache vs. dual-core CPUs
Date: Tue, 25 Apr 2006 21:17:01 -0400
Message-ID: <20060426011701.GB12711@mark.mielke.cc> (raw)
In-Reply-To: <20060426005440.GA12711@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>
On Tue, Apr 25, 2006 at 08:54:40PM -0400, mark@mark.mielke.cc wrote:
> I made the choice I describe based on a lot of research. I was going
> to go both Intel, until I noticed that the Intel prices were dropping
> fast. 30% price cut in 2 months. AMD didn't drop at all during the
> same time.
Errr.. big mistake. That was going to be - I was going to go both AMD.
> There are plenty of reasons to choose one over the other. Generally
> the AMD comes out on top. It is *not* 2X though. Anybody who claims
> this is being highly selective about which benchmarks they consider.
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
Another benefit of Pentium D over AMD X2, at least until AMD chooses
to switch, is that Pentium D supports DDR2, whereas AMD only supports
DDR. There are a lot of technical pros and cons to each - with claims
from AMD that DDR2 can be slower than DDR - but one claim that isn't
often made, but that helped me make my choice:
1) DDR2 supports higher transfer speeds. I'm using DDR2 5400 on
the Intel. I think I'm at 3200 or so on the AMD X2.
2) DDR2 is cheaper. I purchased 1 Gbyte DDR2 5400 for $147 CDN.
1 Gbyte of DDR 3200 starts at around the same price, and
stretches into $200 - $300 CDN.
Now, granted, the Intel 920 requires more electricity to run. Running
24/7 for a year might make the difference in cost.
It doesn't address point 1) though. I like my DDR2 5400.
So, unfortunately, I won't be able to do a good test for you to prove
that my Windows Pentium D box is not only cheaper to buy, but faster,
because the specs aren't exactly equivalent. In the mean time, I'm
quite enjoying my 3d games while doing other things at the same time.
I imagine my desktop load approaches that of a CPU-bound database
load. 3d games require significant I/O and CPU.
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.
Cheers,
mark
--
mark@mielke.cc / markm@ncf.ca / markm@nortel.com __________________________
. . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder
|\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ |
| | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada
One ring to rule them all, one ring to find them, one ring to bring them all
and in the darkness bind them...
http://mark.mielke.cc/
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: mark@mark.mielke.cc, smarlowe@g2switchworks.com, wmoran@collaborativefusion.com
Subject: Re: Large (8M) cache vs. dual-core CPUs
In-Reply-To: <20060426011701.GB12711@mark.mielke.cc>
* 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