pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: J. Andrew Rogers <jrogers@neopolitan.com>
To: pgsql-performance@postgresql.org
Subject: Re: Opteron vs Xeon (Was: What to do with 6 disks?)
Date: Tue, 19 Apr 2005 23:02:28 -0700
Message-ID: <web-8746574@mx1.neopolitan.us> (raw)
In-Reply-To: <Pine.LNX.4.62.0504192134450.21883@discord.dyndns.org>

>I've seen quite a few folks touting the Opteron as 2.5x 
>faster with postgres than a Xeon box.  What makes the 
>Opteron so quick?  Is it that Postgres really prefers to 
>run in 64-bit mode?


I don't know about 2.5x faster (perhaps on specific types 
of loads), but the reason Opterons rock for database 
applications is their insanely good memory bandwidth and 
latency that scales much better than the Xeon.  Opterons 
also have a ccNUMA-esque I/O fabric and two dedicated 
on-die memory channels *per processor* -- no shared bus 
there, closer to real UNIX server iron than a glorified 
PC.

We run a large Postgres database on a dual Opteron in 
32-bit mode that crushes Xeons running at higher clock 
speeds.  It has little to do with bitness or theoretical 
instruction dispatch, and everything to do with the 
superior memory controller and I/O fabric.  Databases are 
all about moving chunks of data around and the Opteron 
systems were engineered to do this very well and in a very 
scalable fashion.  For the money, it is hard to argue with 
the price/performance of Opteron based servers.  We 
started with one dual Opteron postgres server just over a 
year ago (with an equivalent uptime) and have considered 
nothing but Opterons for database servers since.  Opterons 
really are clearly superior to Xeons for this application. 
 I don't work for AMD, just a satisfied customer. :-)


re: 6 disks.  Unless you are tight on disk space, a hot 
spare might be nice as well depending on your needs.

Cheers,

J. Andrew Rogers



view thread (14+ messages)  latest in thread

Message-ID: <web-8746574@mx1.neopolitan.us>
Permalink:  ../web-8746574@mx1.neopolitan.us/
Also on:    postgresql.org/message-id/web-8746574@mx1.neopolitan.us

 · 

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: jrogers@neopolitan.com
  Subject: Re: Opteron vs Xeon (Was: What to do with 6 disks?)
  In-Reply-To: <web-8746574@mx1.neopolitan.us>

* 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