From: Mario Splivalo <mario.splivalo@mobart.hr>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Server Hardware Configuration
Date: Mon, 21 Nov 2005 10:34:36 +0100
Message-ID: <1132565676.8689.9.camel@ekim> (raw)
In-Reply-To: <20051120175337.GP19279@pervasive.com>
References: <E8FEC853EDA289B924D8F213@betelgeuse.cct.rpi.edu>
<20051120175337.GP19279@pervasive.com>
On Sun, 2005-11-20 at 11:53 -0600, Jim C. Nasby wrote:
> Two general comments: most people find that Opterons perform much better
> than Xeons. With some versions of PostgreSQL, the difference is over
> 50%.
Could you be more specific on that? Which version of Postgres perform
better on Opteron than on Xeon?
> RAID5 generally doesn't make for a fast database. The problem is that
> there is a huge amount of overhead everytime you go to write something
> out to a RAID5 array. With careful tuning of the background writer you
> might be able to avoid some of that penalty, though your read
> performance will likely still be affected by the write overhead.
RAID5 was not ment to improve performance, but to minimize disaster and
downtime when your hard disk dies. We're using RAID5 with postgres. In
the last 3 years we changed 5 disks, but the system downtime was zero
minutes.
Mike
--
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mario.splivalo@mobart.hr, jnasby@pervasive.com
Subject: Re: Server Hardware Configuration
In-Reply-To: <1132565676.8689.9.camel@ekim>
References: <E8FEC853EDA289B924D8F213@betelgeuse.cct.rpi.edu> <20051120175337.GP19279@pervasive.com> <1132565676.8689.9.camel@ekim>
* 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