Andrzej Zawadzki wrote:
> Hello,
>
> We're planning new production server for PostgreSQL and I'm wondering
> which processor (or even platform) will be better: Quad Xeon or Quad
> Opteron (for example SUN now has a new offer Sun Fire X4440 x64).
[snip]
> Suggestions?
To get a more useful response here, you might want to include some
information about your workload and database size, and report on your
planned disk subsystem and RAM.
Also, based on what I've seen on this list rather than personal
experience, you might want to give more thought to your storage than to
CPU power. The usual thrust of advice seems to be: Get a fast, battery
backed RAID controller. "Fast" does not mean "fast sequential I/O in
ideal conditions so marketing can print a big number on the box"; you
need to consider random I/O too. Get lots of fast disks. Get enough RAM
to ensure that your indexes fit in RAM if possible.
Note, however, that I have no direct experience with big Pg databases;
I'm just trying to provide you with a guide of what information to
provide and what to think about so you can get better answers here from
people who actually have a clue.
--
Craig Ringer