pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (12+ messages)  latest in thread

Message-ID: <3FB1F28E.702@myrealbox.com>
Permalink:  ../3FB1F28E.702@myrealbox.com/
Also on:    postgresql.org/message-id/3FB1F28E.702@myrealbox.com

 · 

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: 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