Re: which dual-CPU hardware/OS is fastest for PostgreSQL? - Mailing list pgsql-performance

From Greg Stark
Subject Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
Date
Msg-id 87is60ug7z.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: which dual-CPU hardware/OS is fastest for PostgreSQL?  (Jan Dittmer <j.dittmer@portrix.net>)
Responses Re: which dual-CPU hardware/OS is fastest for PostgreSQL?  (Jan Dittmer <j.dittmer@portrix.net>)
List 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 by date:

Previous
From: Alex Turner
Date:
Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
Next
From: "Merlin Moncure"
Date:
Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL?