pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Aidan Van Dyk <aidan@highrise.ca>
To: Mario Weilguni <mweilguni@sime.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Experience with HP Smart Array P400 and SATA drives?
Date: Wed, 10 Dec 2008 10:52:08 -0500
Message-ID: <20081210155208.GR26596@yugib.highrise.ca> (raw)
In-Reply-To: <493FB619.5060205@sime.com>
References: <4934FE60.30702@sime.com>
	<dcc563d10812051500h331ac82fp62142cf611b3a79d@mail.gmail.com>
	<493E6023.3030800@sime.com>
	<1228838308.13962.0.camel@jd-laptop.pragmaticzealot.org>
	<20081209161750.GO26596@yugib.highrise.ca>
	<493FB619.5060205@sime.com>

* Mario Weilguni <mweilguni@sime.com> [081210 07:31]:

> Why not? I know it's not performing as good as RAID-10, but it does not  
> waste 50% diskspace. RAID-6 is no option, because the performance is  
> even worse. And, on another system with RAID-5 + spare and SAS drives,  
> the same controller is working very well.

Like Scott said, it's all about trade-offs.

With raid5, you get abysmal write performance, "make me not sleep at
night" inconsistent parity issues, and a degraded mode that will a
nightmare  ...

... and as a trade-off you save a little money, and get good "read only"
performance ...

... as long as you don't ever have a disk or system crash ...

... or can afford to rebuild if you do ...

... etc ...

-- 
Aidan Van Dyk                                             Create like a god,
aidan@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

Attachments:

  signature.asc (application/pgp-signature, 188B) download

view thread (33+ messages)  latest in thread

Message-ID: <20081210155208.GR26596@yugib.highrise.ca>
Permalink:  ../20081210155208.GR26596@yugib.highrise.ca/
Also on:    postgresql.org/message-id/20081210155208.GR26596@yugib.highrise.ca

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: aidan@highrise.ca, mweilguni@sime.com, jd@commandprompt.com, scott.marlowe@gmail.com
  Subject: Re: Experience with HP Smart Array P400 and SATA drives?
  In-Reply-To: <20081210155208.GR26596@yugib.highrise.ca>

* 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