Re: raid10 write performance

От: Matthew Wakeling
Тема: Re: raid10 write performance
Дата: ,
Msg-id: alpine.DEB.2.00.1006231331580.2534@aragorn.flymine.org
(см: обсуждение, исходный текст)
Ответ на: Re: raid10 write performance  (Ivan Voras)
Список: pgsql-performance

Скрыть дерево обсуждения

raid10 write performance  (Grzegorz Jaśkiewicz, )
 Re: raid10 write performance  (Justin Graf, )
  Re: raid10 write performance  (Karl Denninger, )
   Re: raid10 write performance  (Dave Crooke, )
   Re: raid10 write performance  (Scott Carey, )
 Re: raid10 write performance  (Greg Smith, )
  Re: raid10 write performance  (Ivan Voras, )
   Re: raid10 write performance  (Florian Weimer, )
    Re: raid10 write performance  (Ivan Voras, )
     Re: raid10 write performance  (Matthew Wakeling, )
     Re: raid10 write performance  (Scott Marlowe, )
   Re: raid10 write performance  (Scott Marlowe, )

On Wed, 23 Jun 2010, Ivan Voras wrote:
> On 06/23/10 14:00, Florian Weimer wrote:
>> 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).

No. Write barriers work fine with a single disc, assuming it is set up
correctly. The barrier is a command telling the disc to make sure that one
piece of data is safe before starting to write another piece of data.

However, as soon as you have multiple discs, the individual discs do not
have a way of communicating with each other to make sure that the first
piece of data is written before the other. That's why you need a little
bit of non-volatile storage to mediate that to properly support barriers.

Of course, from a performance point of view, yes, you need some NVRAM on
any kind of spinning storage to maintain high commit rates.

Matthew

--
 I wouldn't be so paranoid if you weren't all out to get me!!


В списке pgsql-performance по дате сообщения:

От: Scott Marlowe
Дата:
Сообщение: Re: Aggressive autovacuuming ?
От: Robert Haas
Дата:
Сообщение: Re: Aggressive autovacuuming ?