Re: Filesystem benchmarking for pg 8.3.3 server

Поиск
Список
Период
Сортировка
От Decibel!
Тема Re: Filesystem benchmarking for pg 8.3.3 server
Дата
Msg-id 04470CDD-146A-4725-BBC5-22E3271B958A@decibel.org
обсуждение исходный текст
Ответ на Re: Filesystem benchmarking for pg 8.3.3 server  (Henrik <henke@mac.se>)
Ответы Re: Filesystem benchmarking for pg 8.3.3 server  (david@lang.hm)
Список pgsql-performance
On Aug 13, 2008, at 2:54 PM, Henrik wrote:
>> Additionally, you need to be careful of what size writes you're
>> using. If you're doing random writes that perfectly align with the
>> raid stripe size, you'll see virtually no RAID5 overhead, and
>> you'll get the performance of N-1 drives, as opposed to RAID10
>> giving you N/2.
> But it still needs to do 2 reads and 2 writes for every write,
> correct?


If you are completely over-writing an entire stripe, there's no
reason to read the existing data; you would just calculate the parity
information from the new data. Any good controller should take that
approach.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Decibel!
Дата:
Сообщение: Re: Experiences storing binary in Postgres
Следующее
От: Decibel!
Дата:
Сообщение: Re: Optimizing a VIEW