Re: Performance on new 64bit server compared to my 32bit desktop - Mailing list pgsql-performance

From Greg Smith
Subject Re: Performance on new 64bit server compared to my 32bit desktop
Date
Msg-id 4C7B3624.1010907@2ndquadrant.com
Whole thread Raw
In response to Re: Performance on new 64bit server compared to my 32bit desktop  (Jose Ildefonso Camargo Tolosa <ildefonso.camargo@gmail.com>)
Responses Re: Performance on new 64bit server compared to my 32bit desktop  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-performance
Jose Ildefonso Camargo Tolosa wrote:
> Also, nowadays, Intel has better performance than AMD, at least when
> comparing Athlon 64 vs Core2, I'm still saving to get a Phenom II
> system in order to benchmark them and see how it goes (does anyone
> have one of these for testing?).
>

Things even out again when you reach the large server line from AMD that
uses DDR-3 RAM; they've finally solved this problem there.  Scott
Marlowe has been helping me out with some tests of a new system he's got
running the AMD Opteron 6172, using the STREAM memory benchmark.  Intro
to that and some sample numbers at
http://www.advancedclustering.com/company-blog/stream-benchmarking.html

He's been seeing >75GB/s of aggregate memory bandwidth out of that
monster--using gcc, so even at a disadvantage compared to the Intel one
used for that report.  If you're only using one or two cores Intel still
seems to have a lead, I am still working out if that's true in every
situation.

I haven't had a chance to test any of the Phenom II processors yet, from
what I know of their design I expect them to still have the same
fundamental design issues that kept all AMD processors from scaling very
well, memory speed wise, the last few years.  You might be able to dig a
system using one of them out of the list at
http://www.cs.virginia.edu/stream/peecee/Bandwidth.html , I didn't
notice anything obvious that featured one.

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


pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: array can be slow when joining?
Next
From: Greg Smith
Date:
Subject: Re: Performance on new 64bit server compared to my 32bit desktop