From: Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
To: Fred Moyer <fred@redhotpenguin.com>
Cc: Chris Field <cfield@affinitysolutions.com>
Cc: Ron Johnson <ron.l.johnson@cox.net>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: Value of Quad vs. Dual Processor machine
Date: Wed, 12 Nov 2003 14:12:54 +0530
Message-ID: <3FB1F28E.702@myrealbox.com> (raw)
In-Reply-To: <000001c3a8cb$87ff7880$0300a8c0@harpua>
References: <000001c3a8cb$87ff7880$0300a8c0@harpua>
Fred Moyer wrote:
> One thing I learned after spending about a week comparing the Athlon (2
> ghz, 333 mhz frontside bus) and Xeon (2.4 ghz, 266 mhz frontside bus)
> platforms was that on average the select queries I was benchmarking ran
> 30% faster on the Athlon (this was with data cached in memory so may not
> apply to the larger data sets where I/O is the limiting factor.)
>
> I benchmarked against the Opteron 244 when it came out and it came in
> about the same as the Athlon (makes sense since both were 333 mhz
> memory). The results within +/- 5-10% that of the Athlon. From testing
> against a couple of other machines I noticed that the memory bus speeds
> were almost directly proportional to the query times under these
> conditions.
I remember a posting here about opteron, which essentially said, even if opteron
works on par with athlon under few clients, as load increases it scales more
than 50% better than athlons.
So that could be another shot at it.Sorry, no handy URL here.
Shridhar
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: shridhar_daithankar@myrealbox.com, fred@redhotpenguin.com, cfield@affinitysolutions.com, ron.l.johnson@cox.net
Subject: Re: Value of Quad vs. Dual Processor machine
In-Reply-To: <3FB1F28E.702@myrealbox.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