We're planning new server or two for PostgreSQL and I'm wondering Intel
Core 2 (Woodcrest for servers?) or Opteron is faster for PostgreSQL now?
When I look through hardware sites Core 2 wins. But I believe those tests
mostly are being done in 32 bits. Does the picture change in 64 bits?
We just migrated from a 4-way opteron @ 2 GHz with 8 GB ram to a DL380
G5 with a 4-way woodcrest @ 3 GHz and 16 GB ram. It was like night and
day, system load dropped, not just quite a bit, but almost by a factor
of 100 in worst case scenarios.
Going from a 64 MB diskcontroller to a 256 MB ditto probably helped
some and so did a speedup from 2 -> 3 GHz, but overall it seems the
new woodcrest cpu's feel at home doing db-stuff.
This is on FreeBSD 6.2 RC1 and postgresql 7.4.14.
And I also remember that in PostgreSQL Opteron earlier had huge advantage
over older Xeons. But did Intel manage to change picture now?
That was pre-woodcrest, aka. nocona and before. Horrible and the
reason I went for opteron to begin with. But AMD probably wont sit
idle.
The link posted in another reply illustrates the current situation quite well.
regards
Claus
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match