From: Craig Ringer <craig@postnewspapers.com.au>
To: Andrzej Zawadzki <zawadaa@wp.pl>
Cc: pgsql-performance@postgresql.org
Subject: Re: Quad Xeon or Quad Opteron?
Date: Fri, 23 May 2008 19:34:41 +0800
Message-ID: <4836ABD1.1060904@postnewspapers.com.au> (raw)
In-Reply-To: <48369F59.60902@wp.pl>
References: <48369F59.60902@wp.pl>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig@postnewspapers.com.au, zawadaa@wp.pl
Subject: Re: Quad Xeon or Quad Opteron?
In-Reply-To: <4836ABD1.1060904@postnewspapers.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox