DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=NQ9rOruHU2UuaX5blFauvBJI7D9xJLsWEREhkNDFUPZZ7scS6lQsrTO0bwjlxlvofn5AVYmEXyHrp1bIBAaDJ0HJONs/7T91NYnnQlMFfMHqe/ri+jrzVA8dNCGyNTtyD93/P3R/4IxG2TVvDnAnqVGcSPFqRYDx7vHlThVeJVk=
Message-ID: <f3c0b4080508301150a82d5dc@mail.gmail.com>
Date: Tue, 30 Aug 2005 13:50:16 -0500
From: Matthew Nuzum <mattnuzum@gmail.com>
Reply-To: newz@bearfruit.org
To: pgsql-performance@postgresql.org
Subject: Re: RAID Configuration Sugestion
In-Reply-To: <6.2.3.4.0.20050830132902.021a5308@pop.earthlink.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <431452FD.3090402@atua.com.br>
	<6.2.3.4.0.20050830103240.0219b640@pop.earthlink.net>
	<43148FC4.4000407@commandprompt.com>
	<6.2.3.4.0.20050830132902.021a5308@pop.earthlink.net>

On 8/30/05, Ron <rjpeace@earthlink.net> wrote:
> >If you still have the budget, I would suggest considering either
> >what Ron suggested or possibly using a 4 drive RAID 10 instead.
>=20
> IME, with only 4 HDs, it's usually better to split them them into two
> RAID 1's (one for the db, one for everything else including the logs)
> than it is to put everything on one RAID 10.  YMMV.

This coresponds to what I have observed as well. Of course, we all
know that work loads varry.

Just a note for the OP who has only two drives, there are tools for a
variety of OSs that monitor the S.M.A.R.T. features of the drive and
give an early warning in case it senses impending failure. I've caught
two drives before failure with these types of tools.

Also note that when reading discussions of this nature you must take
into consideration the value of your data. For some people, restoring
from a nightly backup is inconvienent, but not life-or-death. Some
people even do twice-daily backups so that in case of a failure they
can recover with little loss of data. This might be a good way to
mitigate the cost of expensive server hardware. If you cannot afford
to lose any data then you need to consider it imperitive to use some
type of RAID setup (not RAID 0) and to achieve great performance
you'll want more than 2 drives.
--=20
Matthew Nuzum
www.bearfruit.org