Skip site navigation (1) Skip section navigation (2)

Re: raid10 write performance

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Ivan Voras <ivoras(at)freebsd(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: raid10 write performance
Date: 2010-06-23 12:54:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Wed, Jun 23, 2010 at 8:25 AM, Ivan Voras <ivoras(at)freebsd(dot)org> wrote:
> On 06/23/10 14:00, Florian Weimer wrote:
>> * Ivan Voras:
>>> On the other hand, RAID10 is simple enough that soft-RAID
>>> implementations should be more than adequate - any ideas why a dedicated
>>> card has it "slow"?
>> Barrier support on RAID10 seems to require some smallish amount of
>> non-volatile storage which supports a high number of write operations
>> per second, so a software-only solution might not be available.
> If I understand you correctly, this can be said in general for all
> spinning-disk usage and is not specific to RAID10. (And in the case of
> high, constant TPS, no amount of NVRAM will help you).

Not entirely true.  Let's say you have enough battery backed cache to
hold 10,000 transaction writes in memory at once.  The RAID controller
can now re-order those writes so that they go from one side of the
disk to the other, instead of randomly all over the place.  That will
most certainly help improve your throughput.

In response to

pgsql-performance by date

Next:From: Scott MarloweDate: 2010-06-23 12:56:39
Subject: Re: raid10 write performance
Previous:From: Matthew WakelingDate: 2010-06-23 12:46:13
Subject: Re: raid10 write performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group