Re: Postgresql on software RAID

From: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql on software RAID
Date: 2003-12-17 04:52:56
Message-ID: 20031216215256.6c815f64.Robert_Creager@LogicalChaos.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

When grilled further on (Tue, 16 Dec 2003 22:30:04 -0600),
Patrick Spinler <spinler(at)kmtel(dot)com> confessed:

>
> 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.
>

Kind of related and a point of reference. We use ClearCase and have many
multiple Gb vob's(databases). We were using RAID-5, but had to back off to RAID
0+1 because of performance reasons (which was indicated in the manual, once you
read it...). This would happen around 1-2Gb's vob size. Our usage of CC
provides heavy writing activity to the underlying dB.

I don't know what kind of dB engine Atria->Rational->IBM has implemented
underneath, or even it it would look like a dB to someone who knew the
difference...

Cheers,
Rob

--
21:42:33 up 4 days, 13:15, 1 user, load average: 2.23, 2.10, 2.10

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2003-12-17 06:19:12 Re: Postgresql on software RAID
Previous Message Patrick Spinler 2003-12-17 04:41:29 Re: comparing with oracle