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

From Robert Haas
Subject Re: raid10 hard disk choice
Date
Msg-id 603c8f070905211329v7d648047u2b2b27e5ce59cce3@mail.gmail.com
Whole thread Raw
In response to Re: raid10 hard disk choice  (Matthew Wakeling <matthew@flymine.org>)
Responses Re: raid10 hard disk choice  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
On Thu, May 21, 2009 at 8:59 AM, Matthew Wakeling <matthew@flymine.org> wrote:
> On Thu, 21 May 2009, Linos wrote:
>>
>>        i have to buy a new server and in the budget i have (small) i have
>> to select one of this two options:
>>
>> -4 sas 146gb 15k rpm raid10.
>> -8 sas 146gb 10k rpm raid10.
>
> It depends what you are doing. I think in most situations, the second option
> is better, but there may be a few situations where the reverse is true.

One possible case of this - I believe that 15K drives will allow you
to commit ~250 times per second (15K/60) vs. ~166 times per second
(10K/60).  If you have a lot of small write transactions, this might
be an issue.

...Robert

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: raid10 hard disk choice
Next
From: Scott Marlowe
Date:
Subject: Re: raid10 hard disk choice