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