Re: Advice on RAID card - Mailing list pgsql-performance

From Michael Stone
Subject Re: Advice on RAID card
Date
Msg-id 20050925181352.GA2241@mathom.us
Whole thread Raw
In response to Re: Advice on RAID card  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
On Sun, Sep 25, 2005 at 01:41:06PM -0400, Greg Stark wrote:
>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.

Software raid 5 actually may have an advantage here. The main cause for
high raid5 write latency is the necessity of having blocks from each
disk available to calculate the parity. The chances of a pc with several
gigs of ram having all the blocks cached (thus not requiring any reads)
are higher than on a hardware raid with several hundred megs of ram.

Mike Stone

pgsql-performance by date:

Previous
From: "Ahmad Fajar"
Date:
Subject: Re: tsearch2 seem very slow
Next
From: "Luke Lonergan"
Date:
Subject: Re: Advice on RAID card