Re: Postgresql on software RAID - Mailing list pgsql-admin

From Sean Chittenden
Subject Re: Postgresql on software RAID
Date
Msg-id 20031218053906.GA30854@perrin.nxad.com
Whole thread Raw
In response to Postgresql on software RAID  (Adam Witney <awitney@sghms.ac.uk>)
Responses Re: Postgresql on software RAID
List pgsql-admin
> I am experimenting with a few OS's for my new hardware. I plan to have a
> software RAID5 device for my pgsql data directory.
>
> I have been experimenting with FreeBSD and with Linux, does anyone have any
> thoughts on whether vinum RAID devices are better than Linux software RAID?
> Or vice versa... Or no difference at all? Any gotchas I should bear in mind?

You have to be more specific than just software RAID... IDE software
RAID helps with reliability, but it's murder on performance.  Only one
command can be issued at a time with IDE, so your performance of RAID
1 is going to be half that of just writing to a single device.  SCSI
on the other hand...  SCSI is the only way to go if you're serious
about databases.  -sc

--
Sean Chittenden

pgsql-admin by date:

Previous
From: Robert Creager
Date:
Subject: Re: Postgresql on software RAID
Next
From: Mitchell Laks
Date:
Subject: Re: Postgresql on software RAID