Skip site navigation (1) Skip section navigation (2)

Re: RAID Configuration Sugestion

From: Matthew Nuzum <mattnuzum(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: RAID Configuration Sugestion
Date: 2005-08-30 18:50:16
Message-ID: f3c0b4080508301150a82d5dc@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 8/30/05, Ron <rjpeace(at)earthlink(dot)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.
> 
> 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.
-- 
Matthew Nuzum
www.bearfruit.org

In response to

pgsql-performance by date

Next:From: Rémy BeaumontDate: 2005-08-30 18:50:35
Subject: Re: High load and iowait but no disk access
Previous:From: Anjan DaveDate: 2005-08-30 18:46:10
Subject: Re: High load and iowait but no disk access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group