pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Stark <gsstark@mit.edu>
To: PFC <lists@boutiquenumerique.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: Dave Cramer <pg@fastcrypt.com>
Cc: Michael Ben-Nes <miki@canaan.co.il>
Cc: pgsql-performance@postgresql.org
Subject: Re: Advice on RAID card
Date: 25 Sep 2005 13:41:06 -0400
Message-ID: <873bntjb9p.fsf@stark.xeocode.com> (raw)
In-Reply-To: <op.sxn3v7a1th1vuj@localhost>
References: <IGEGINLEEDLANNHAAKCMOECJCCAA.gaulakh@ecmarket.com>
	<op.sxll3du6th1vuj@localhost>
	<43367937.40809@canaan.co.il>
	<ABE6B997-2C1E-43B1-9F18-28F54B1620FE@fastcrypt.com>
	<4336C57B.6090800@commandprompt.com>
	<op.sxn1sdofth1vuj@localhost>
	<4336CEAA.7070208@commandprompt.com>
	<op.sxn3v7a1th1vuj@localhost>

PFC <lists@boutiquenumerique.com> writes:

> 	Which makes me think that I will use Software Raid 5 and convert the
> price of the card into RAM.
> 	This should be nice for a budget server.
> 	Gonna investigate now if Linux software RAID5 is rugged enough. Can
> always buy the a card later if not.

Raid 5 is perhaps the exception here. For Raid 5 a substantial amount of CPU
power is needed.

Also, Raid 5 is particularly inappropriate for write-heavy Database traffic.
Raid 5 actually hurts write latency dramatically and Databases are very
sensitive to latency.

On the other hand if your database is primarily read-only then Raid 5 may not
be a problem and may be faster than raid 1+0.

-- 
greg




view thread (18+ messages)  latest in thread

Message-ID: <873bntjb9p.fsf@stark.xeocode.com>
Permalink:  ../873bntjb9p.fsf@stark.xeocode.com/
Also on:    postgresql.org/message-id/873bntjb9p.fsf@stark.xeocode.com

 · 

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: gsstark@mit.edu, lists@boutiquenumerique.com, jd@commandprompt.com, pg@fastcrypt.com, miki@canaan.co.il
  Subject: Re: Advice on RAID card
  In-Reply-To: <873bntjb9p.fsf@stark.xeocode.com>

* 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