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

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
Дата
Msg-id 87is60ug7z.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: which dual-CPU hardware/OS is fastest for PostgreSQL?  (Jan Dittmer <j.dittmer@portrix.net>)
Ответы Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
Список pgsql-performance
Jan Dittmer <j.dittmer@portrix.net> writes:

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

Aren't you much better off doing raid 0 over raid 1?

With raid 1 over raid 0 you're mirroring two stripe sets. That means if any
drive from the first stripe set goes you lose the whole side of the mirror. If
any drive of the second stripe set goes you lost your array. Even if they're
not the same position in the array.

If you do raid 0 over raid 1 then you're striping a series of mirrored drives.
So if any drive fails you only lose that drive from the stripe set. If another
drive fails then you're ok as long as it isn't the specific drive that was
paired with the first failed drive.

--
greg

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

Предыдущее
От: Alex Turner
Дата:
Сообщение: Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: which dual-CPU hardware/OS is fastest for PostgreSQL?