Re: Recomended FS

From: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>
To: <holger(at)marzen(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Recomended FS
Date: 2003-10-21 09:00:41
Message-ID: 2266D0630E43BB4290742247C891057502B9D2C9@dozer.computec.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Theory vs. real life. In Theory, RAID5 is faster because less
> data have
> to be written to disk. But it's true, many RAID5 controllers
> don't have
> enough CPU power.

I think it might not be just CPU-power of the controller. For RAID0+1
you just have two disc-I/O per write-access: writing to the original set
and the mirror-set. For RAID5 you have three additional
disc-I/O-processes: 1. Read the original data block, 2. read the parity
block (and calculate the new parity block, which is not a disk I/O), 3.
write the updated data block and 4. write the updated parity block. Thus
recommendations by IBM for DB/2 and several Oracle-consultants state
that RAID5 is the best compromise for storage vs. transaction speed, but
if your main concern is the latter, you're always best of with RAID0+1;
RAID0+1 does indeed always and reproducably have better write
performance that RAID0+1 and read-performance is almost always also
slightly better.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben-Nes Michael 2003-10-21 09:42:50 Re: Recomended FS
Previous Message Johnson, Shaunn 2003-10-21 08:49:24 Re: how to use pg_resetxlog