pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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."





view thread (16+ messages)  latest in thread

Message-ID: <1132565676.8689.9.camel@ekim>
Permalink:  ../1132565676.8689.9.camel@ekim/
Also on:    postgresql.org/message-id/1132565676.8689.9.camel@ekim

 · 

reply

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