Re: AMD Shanghai versus Intel Nehalem

From: Scott Carey <scott(at)richrelevance(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: AMD Shanghai versus Intel Nehalem
Date: 2009-05-13 16:58:41
Message-ID: C6304A51.5FBB%scott@richrelevance.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 5/12/09 10:06 PM, "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> wrote:

> Just realized I made a mistake, I was under the impression that
> Shanghai CPUs had 8xxx numbers while barcelona had 23xx numbers. I
> was wrong, it appears the 8xxx numbers are for 4+ socket servers while
> the 23xx numbers are for 2 or fewer sockets. So, there are several
> quite affordable shanghai cpus out there, and many of the ones I
> quoted as barcelonas are in fact shanghais with the larger 6M L2
> cache.
>

At this point, I wouldn¹t go below 5520 on the Nehalem side (turbo + HT is
just too big a jump, as is the 1066Mhz versus 800Mhz memory jump). Its $100
extra per CPU on a $10K + machine.
The next 'step' is the 5550, since it can run 1333Mhz memory and has 2x the
turbo -- but you would have to be more CPU bound for that. I wouldn't worry
about the 5530 or 5540, they will only scale a little up from the 5520.

For Opterons, I wouldn't touch anything but a Shanghai these days since its
just not much more and we know the cache differences are very important for
DB loads.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2009-05-13 17:06:22 Re: Any better plan for this query?..
Previous Message Scott Carey 2009-05-13 16:42:42 Re: Any better plan for this query?..