On Wed, Jun 23, 2010 at 8:25 AM, Ivan Voras <ivoras@xxxxxxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
