pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron <rjpeace@earthlink.net>
To: Alvaro Nunes Melo <al_nunes@atua.com.br>
To: PostgreSQL - Performance <pgsql-performance@postgresql.org>
Subject: Re: RAID Configuration Sugestion
Date: Tue, 30 Aug 2005 10:45:15 -0400
Message-ID: <6.2.3.4.0.20050830103240.0219b640@pop.earthlink.net> (raw)
In-Reply-To: <431452FD.3090402@atua.com.br>
References: <431452FD.3090402@atua.com.br>

At 08:37 AM 8/30/2005, Alvaro Nunes Melo wrote:
>Hello,
>
>We are about to install a new PostgreSQL server, and despite of 
>being a very humble configuration compared to the ones we see in the 
>list, it's the biggest one we've got till now.
>
>The server is a Dual Xeon 3.0 with 2 GB RAM and two SCSI disks. Our 
>main doubt is what is the best configuration for the disks. We are 
>thinking about use them in a RAID-0 array. Is this the best option? 
>What do you suggest on partitioning? Separate partitions for the OS, 
>data and pg_xlog?

This is _very_ modest HW.  Unless your DB and/or DB load is similarly 
modest, you are not going to be happy with the performance of your DBMS.

At a minimum, for safety reasons you want 4 HDs: 2 for a RAID 1 set 
for the DB, and 2 for a RAID 1 set for the OS + pg_xlog.
2 extra HDs, even SCSI HDs, is cheap.  Especially when compared to 
the cost of corrupted or lost data.

HD's and RAM are cheap enough that you should be able to upgrade in 
more ways, but do at least that "upgrade"!

Beyond that, the best ways to spend you limited $ are highly 
dependent on your exact DB and its usage pattern.

Ron Peacetree





view thread (14+ messages)  latest in thread

Message-ID: <6.2.3.4.0.20050830103240.0219b640@pop.earthlink.net>
Permalink:  ../6.2.3.4.0.20050830103240.0219b640@pop.earthlink.net/
Also on:    postgresql.org/message-id/6.2.3.4.0.20050830103240.0219b640@pop.earthlink.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: rjpeace@earthlink.net, al_nunes@atua.com.br
  Subject: Re: RAID Configuration Sugestion
  In-Reply-To: <6.2.3.4.0.20050830103240.0219b640@pop.earthlink.net>
  References: <431452FD.3090402@atua.com.br> <6.2.3.4.0.20050830103240.0219b640@pop.earthlink.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox