Re: which dual-CPU hardware/OS is fastest for PostgreSQL?

Поиск
Список
Период
Сортировка
От Jan Dittmer
Тема Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
Дата
Msg-id 41E3A780.3020505@portrix.net
обсуждение исходный текст
Ответ на Re: which dual-CPU hardware/OS is fastest for PostgreSQL?  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: which dual-CPU hardware/OS is fastest for PostgreSQL?  (Greg Stark <gsstark@mit.edu>)
Список pgsql-performance
Joshua D. Drake wrote:
>>RAID controllers tend to use i960 or StrongARM CPUs that run at speeds
>>that _aren't_ all that impressive.  With software RAID, you can take
>>advantage of the _enormous_ increases in the speed of the main CPU.
>>
>>I don't know so much about FreeBSD's handling of this, but on Linux,
>>there's pretty strong indication that _SOFTWARE_ RAID is faster than
>>hardware RAID.
>>
>>
>
> Unless something has changed though, you can't run raid 10
> with linux software raid and raid 5 sucks for heavy writes.

You could always do raid 1 over raid 0, with newer kernels (2.6ish)
there is even a dedicated raid10 driver.

Jan

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

Предыдущее
От: Madison Kelly
Дата:
Сообщение: sum of all values
Следующее
От: "Pete de Zwart"
Дата:
Сообщение: Best filesystem for PostgreSQL Database Cluster under Linux