From: Adam Tauno Williams <adamtaunowilliams@gmail.com>
To: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Quad Xeon or Quad Opteron?
Date: Fri, 23 May 2008 08:21:57 -0400
Message-ID: <1211545317.4704.2.camel@WM_ADAM1.morrison.iserv.net> (raw)
In-Reply-To: <4836ABD1.1060904@postnewspapers.com.au>
References: <48369F59.60902@wp.pl>
<4836ABD1.1060904@postnewspapers.com.au>
> 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.
Yep, we've had PostreSQL databases for a long time. The various
current generation processors, IMO, have no substantive difference in
practice; at least not relative to the bang-for-the-buck or more RAM
and good I/O.
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: adamtaunowilliams@gmail.com
Subject: Re: Quad Xeon or Quad Opteron?
In-Reply-To: <1211545317.4704.2.camel@WM_ADAM1.morrison.iserv.net>
* 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