Re: raid10 hard disk choice - Mailing list pgsql-performance

From Greg Smith
Subject Re: raid10 hard disk choice
Date
Msg-id alpine.GSO.2.01.0905220255340.20560@westnet.com
Whole thread Raw
In response to Re: raid10 hard disk choice  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
On Thu, 21 May 2009, Scott Marlowe wrote:

> But in a RAID-10 you aggreate pairs like RAID-0, so you could write
> 250(n/2) times per second on 15k where n=4 and 166(n/2) for 10k drives
> where n=8.  So 500 versus 664... ?  Or am I getting it wrong.

Adding more spindles doesn't improve the fact that the disks can only
commit once per revolution.  WAL writes are way too fine grained for them
to get split across stripes to improve the commit rate.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: raid10 hard disk choice
Next
From: Greg Smith
Date:
Subject: Re: raid10 hard disk choice