Re: Arguments Pro/Contra Software Raid - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Arguments Pro/Contra Software Raid
Date
Msg-id 20060509151848.GA11476@wolff.to
Whole thread Raw
In response to Re: Arguments Pro/Contra Software Raid  ("Jean-Yves F. Barbier" <7ukwn@free.fr>)
List pgsql-general
On Tue, May 09, 2006 at 12:10:32 +0200,
  "Jean-Yves F. Barbier" <7ukwn@free.fr> wrote:
> Naa, you can find ATA &| SATA ctrlrs for about EUR30 !

But those are the ones that you would generally be better off not using.

> Definitely NOT, however if your server doen't have a heavy load, the
> software overload can't be noticed (essentially cache managing and
> syncing)

It is fairly common for database machines to be IO, rather than CPU, bound
and so the CPU impact of software raid is low.

> Some hardware ctrlrs are able to avoid the loss of a disk if you turn
> to have some faulty sectors (by relocating internally them); software
> RAID doesn't as sectors *must* be @ the same (linear) addresses.

That is not true. Software raid works just fine on drives that have internally
remapped sectors.

pgsql-general by date:

Previous
From: Reid Thompson
Date:
Subject: Re: What is your favorite front end for user interaction
Next
From: "Karl O. Pinc"
Date:
Subject: Re: pg_restore duplicate key violations