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@xxxxxxxxxxxx wrote:
pgsql-general-owner@xxxxxxxxxxxxxx wrote on 04/22/2005 10:08:46 AM:
On Fri, 2005-04-22 at 09:48, Richard_D_Levine@xxxxxxxxxxxx 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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
