Re: Postgresql on software RAID

From: Patrick Spinler <spinler(at)kmtel(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
Subject: Re: Postgresql on software RAID
Date: 2003-12-17 04:30:04
Message-ID: 3FDFDBCC.6060609@kmtel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Adam Witney wrote:
> Hi all,
>
> 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?
>

Of interest, there are a number of "old school" dba's of my aquantance
who swear vociferously whenever the words RAID 5 and Database are
mentioned in association with each other.

According to the theory they expound, a database with any significant
write activity whatsoever should never be on raid 5, but instead be on
raid 0+1.

I've never had a chance to benchmark a comparison between the two and
draw my own conclusions, but it might be interesting to do so.

-- Pat

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Patrick Spinler 2003-12-17 04:41:29 Re: comparing with oracle
Previous Message sachdev 2003-12-17 04:02:31 Re: comparing with oracle