Re: UltraSPARC versus AMD - Mailing list pgsql-general

Aceshardware.com has a good UI for looking at Spec scores. They imported
all the results into their DB for easily comparisons between processors.

Single CPU (individual queries):


http://www.aceshardware.com/SPECmine/index.jsp?b=0&s=0&v=4&if=0&if=1&if=2&a=0&a=1&a=2&a=3&a=5&a=6&a=7&ncf=1&nct=1&cpcf=1&cpct=1&mf=1&mt=4000&o=0&o=1

Quad CPU SMP performance:


http://www.aceshardware.com/SPECmine/index.jsp?b=1&s=0&v=4&if=0&if=1&if=2&a=0&a=1&a=2&a=3&a=5&a=6&a=7&ncf=1&nct=4&cpcf=1&cpct=4&mf=250&mt=3800&o=0&o=1

Money is no object performance:


http://www.aceshardware.com/SPECmine/index.jsp?b=1&s=0&v=4&if=0&if=1&if=2&a=0&a=1&a=2&a=3&a=5&a=6&a=7&ncf=1&nct=256&cpcf=1&cpct=256&mf=250&mt=3800&o=0&o=1

The numbers don't have the latest dual core Opterons yet. (Don't see
them on spec.org yet either.) My random guess right now, 4x2 system
would probably be about 140 SpecINT_rate. It's looking like it's faster
than have a DC Opteron w/ 1 memory bank versus Dual Opteron w/ 2 memory
bank because the interconnect between cores inside a DC CPU is so much
faster than the HT motherboard connect.



Richard_D_Levine@raytheon.com wrote:
>
> pgsql-general-owner@postgresql.org wrote on 04/22/2005 10:08:46 AM:
>
>
>>On Fri, 2005-04-22 at 09:48, Richard_D_Levine@raytheon.com wrote:
>>
>>>I just got done comparing SPECMarks (on spec.org) between Sun's AMD
>
> entry
>
>>>level servers versus similarly configured UltraSPARCs versus desktop
>
> AMD
>
>>>based machines.  Sun's AMD machines are twice as fast as their
>
> UItraSPARCs,
>
>>>for approximately the same price.  What a hoot.
>>
>>Wow.  I'd certainly like to see the numbers and such from your
>>benchmarks.  I have to say I'm not surprised, the 64 bit AMD chips are
>>quite impressive pieces of hardware.
>
>
> The benchmarks aren't mine, they're standard performance evaluation (SPEC)
> defined by spec.org
>
> http://www.spec.org
>
> Click on the desired benchmark (I was referring to the CPU benchmarks) and
> click on "published results".
>
> The manufacturers (Sun, Dell, HP, etc.) buy the benchmarks, configure their
> best compiler for speed, run them, and submit the results.  My point is
> that Sun ran the benchmarks, under very strict rules set forth by SPEC.
>
> Rick
>
>
>>---------------------------(end of broadcast)---------------------------
>>TIP 9: the planner will ignore your desire to choose an index scan if
>
> your
>
>>      joining column's datatypes do not match
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>