Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 3A6BA633F94 for ; Mon, 30 Aug 2010 19:32:05 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 64139-04 for ; Mon, 30 Aug 2010 22:31:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9]) by mail.postgresql.org (Postfix) with ESMTP id 5AE38633CF3 for ; Mon, 30 Aug 2010 19:31:57 -0300 (ADT) Received: from [192.168.1.6] (static-71-179-240-8.bltmmd.fios.verizon.net [71.179.240.8]) by mrelayeu.kundenserver.de (node=mrbap1) with ESMTP (Nemesis) id 0Lfps2-1PAeXY2KAE-00pVzt; Tue, 31 Aug 2010 00:31:55 +0200 Message-ID: <4C7C3159.9040700@2ndquadrant.com> Date: Mon, 30 Aug 2010 18:31:53 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Clemens Eisserer CC: pgsql-performance@postgresql.org Subject: Re: Performance on new 64bit server compared to my 32bit desktop References: <4C6CE64D.6070104@edd.fr> <4C6D76FE.9010407@2ndquadrant.com> <4C77F4F4.4020900@2ndquadrant.com> <4C7BCB13.7000709@2ndquadrant.com> In-Reply-To: Content-Type: multipart/alternative; boundary="------------060909020806090202080607" X-Provags-ID: V02:K0:HmzwQGRS8tHlmSYtWvaEnOGFbju29Kv+iOEvuWzG93w EAc2wMqXrnP4Dp8KZrOLT7qoTe1ZMfxS6r1P6qudLIxyBNC1MK 2/I3uzUhZ/yYDbuIyHzQv4FWr6evdKHRfwIZuGW0hP5oRGgLNU BH0VewU+UXNwwRuH0KSP/+Me1hedKsQFX6ARzofvRT+dBJPTgQ 6rsUTKvMYcvONoR0lgbkrRZBMUeeVGX7pY1GcO84Tw= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/343 X-Sequence-Number: 40186 This is a multi-part message in MIME format. --------------060909020806090202080607 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Clemens Eisserer wrote: > Hi, > > >>> This isn't an older Opteron, its 6 core, 6MB L3 cache "Istanbul". Its not >>> the newer stuff either. >>> >> Everything before Magny Cours is now an older Opteron from my perspective. >> > > The 6-cores are identical to Magny Cours (except that Magny Cours has > two of those beast in one package). > In some ways, but not in regards to memory issues. http://www.anandtech.com/show/2978/amd-s-12-core-magny-cours-opteron-6174-vs-intel-s-6-core-xeon/2 has a good intro. While the inside is like two 6-core models stuck together, the external memory interface was completely reworked. Original report here involved Opteron 2427, correctly idenitified as being from the 6-core "Istanbul" architecture. All Istanbul processors use DDR2 and are quite slow at memory access compared to similar Intel Nehalem systems. The "Magny-Cours" architecture is available in 8 and 12 core variants, and the memory controller has been completely redesigned to take advantage of many banks of DDR3 at the same time; it is far faster than two of the older 6 cores working together. http://en.wikipedia.org/wiki/List_of_AMD_Opteron_microprocessors has a good summary of the models; it's confusing. Quick chart showing the three generations compared demonstrates what I just said above using the same STREAM benchmarking that a few results have popped out here using already: http://www.anandtech.com/show/2978/amd-s-12-core-magny-cours-opteron-6174-vs-intel-s-6-core-xeon/5 Istanbul Opteron 2435 in this case, 21GB/s. The two Nehelam Intel Xeons, >31GB/s. New Magny, 49MB/s. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us --------------060909020806090202080607 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit Clemens Eisserer wrote: 
Hi,

  
This isn't an older Opteron, its 6 core, 6MB L3 cache "Istanbul".  Its not
the newer stuff either.
      
Everything before Magny Cours is now an older Opteron from my perspective.
    

The 6-cores are identical to Magny Cours (except that Magny Cours has
two of those beast in one package).

In some ways, but not in regards to memory issues.  http://www.anandtech.com/show/2978/amd-s-12-core-magny-cours-opteron-6174-vs-intel-s-6-core-xeon/2 has a good intro.  While the inside is like two 6-core models stuck together, the external memory interface was completely reworked.

Original report here involved Opteron 2427, correctly idenitified as being from the 6-core "Istanbul" architecture.  All Istanbul processors use DDR2 and are quite slow at memory access compared to similar Intel Nehalem systems.  The "Magny-Cours" architecture is available in 8 and 12 core variants, and the memory controller has been completely redesigned to take advantage of many banks of DDR3 at the same time; it is far faster than two of the older 6 cores working together.

http://en.wikipedia.org/wiki/List_of_AMD_Opteron_microprocessors has a good summary of the models; it's confusing.  Quick chart showing the three generations compared demonstrates what I just said above using the same STREAM benchmarking that a few results have popped out here using already:

http://www.anandtech.com/show/2978/amd-s-12-core-magny-cours-opteron-6174-vs-intel-s-6-core-xeon/5

Istanbul Opteron 2435 in this case, 21GB/s.  The two Nehelam Intel Xeons, >31GB/s.  New Magny, 49MB/s.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us
--------------060909020806090202080607--