pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Greg Smith <greg@2ndquadrant.com>
Cc: Bob Dusek <redusek@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: performance config help
Date: Mon, 11 Jan 2010 15:44:18 -0700
Message-ID: <dcc563d11001111444w6251c638y2aa39f386fb0d1d8@mail.gmail.com> (raw)
In-Reply-To: <4B4BA058.4070703@2ndquadrant.com>
References: <61039b861001110544o2c352763q13dcf9d78a156714@mail.gmail.com>
	<dcc563d11001110550s2af6d559l5db495d5e0fc6a57@mail.gmail.com>
	<61039b861001110842g15bb1f26jc50b6e6762e01427@mail.gmail.com>
	<dcc563d11001110934n7c97be5cv5801289da116b87e@mail.gmail.com>
	<61039b861001110949n699f0bd1pf3c878fa4c739891@mail.gmail.com>
	<dcc563d11001111019p11aa8ca4p850213df48e6ad39@mail.gmail.com>
	<4B4BA058.4070703@2ndquadrant.com>

On Mon, Jan 11, 2010 at 3:04 PM, Greg Smith <greg@2ndquadrant.com> wrote:
> Scott Marlowe wrote:
>>
>> So, I took a break from writing and searched for some more info on the
>> 74xx series CPUs, and from reading lots of articles, including this
>> one:
>> http://www.anandtech.com/cpuchipsets/intel/showdoc.aspx?i=3414
>> It seems apparent that the 74xx series if a great CPU, as long as
>> you're not memory bound.
>>
>
> This is why I regularly end up recommending people consider Intel's designs
> here so often, the ones that use triple-channel DDR3, instead of any of the
> AMD ones.  It's extremely easy to end up with a memory-bound workload
> nowadays, at which point all the CPU power in the world doesn't help you
> anymore.

The DDR3 Nehalem and DDR2 AMD are both actually pretty close in real
world use on 4 or more socket machines.  Most benchmarks on memory
bandwidth give no huge advantage to either one or the other.  They
both max out at about 25GB/s.

It's the older Xeon base 74xx chipsets without integrated memory
controllers that seem to have such horrible bandwidth because they're
not multi-channel.

For dual socket the Nehalem is pretty much the king.  By the time you
get to 8 sockets AMD is still ahead.  Just avoid anything older than
nehalem or istanbul.



view thread (46+ messages)  latest in thread

Message-ID: <dcc563d11001111444w6251c638y2aa39f386fb0d1d8@mail.gmail.com>
Permalink:  ../dcc563d11001111444w6251c638y2aa39f386fb0d1d8@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d11001111444w6251c638y2aa39f386fb0d1d8@mail.gmail.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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: scott.marlowe@gmail.com, greg@2ndquadrant.com, redusek@gmail.com
  Subject: Re: performance config help
  In-Reply-To: <dcc563d11001111444w6251c638y2aa39f386fb0d1d8@mail.gmail.com>
  References: <61039b861001110544o2c352763q13dcf9d78a156714@mail.gmail.com> <dcc563d11001110550s2af6d559l5db495d5e0fc6a57@mail.gmail.com> <61039b861001110842g15bb1f26jc50b6e6762e01427@mail.gmail.com> <dcc563d11001110934n7c97be5cv5801289da116b87e@mail.gmail.com> <61039b861001110949n699f0bd1pf3c878fa4c739891@mail.gmail.com> <dcc563d11001111019p11aa8ca4p850213df48e6ad39@mail.gmail.com> <4B4BA058.4070703@2ndquadrant.com> <dcc563d11001111444w6251c638y2aa39f386fb0d1d8@mail.gmail.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