From: Decibel! <decibel@decibel.org>
To: Michael Ben-Nes <miki@epoch.co.il>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: RAID 10 or RAID 10 + RAID 1
Date: Tue, 14 Aug 2007 16:31:50 -0500
Message-ID: <20070814213150.GT54135@nasby.net> (raw)
In-Reply-To: <f3be18fa0708140314v69bc7c5ake34f4a46e9c378b1@mail.gmail.com>
References: <f3be18fa0708140314v69bc7c5ake34f4a46e9c378b1@mail.gmail.com>
On Tue, Aug 14, 2007 at 01:14:39PM +0300, Michael Ben-Nes wrote:
> Hello,
>
> I need to setup a web server with PostgreSQL. The heaviest application will
> be product comparisons engine that will analyze 5-10 Million products.
>
> I have 6 SAS 15K disks, how should I set them up:
>
> RAID 10 on all 6 disks ( OS + Apache + PostgreSQL )
> RAID 1 on 2 disks ( OS + Apache ) + RAID 10 on 4 disks ( PostgreSQL )
If the controller is any good and has a battery-backed write cache,
you'll probably do better with a 6 disk RAID10. If not, I'd put all the
data on a 4 disk RAID10, and everything else (including pg_xlog!) on a
mirror.
> What is the recommended stripe size ( The computer is Dell PowerEdge 2950 )
If you search through the archives I think you'll find some stuff about
stripe size and performance.
As always, your best bet is to benchmark both approaches with your
actual application.
--
Decibel!, aka Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: decibel@decibel.org, miki@epoch.co.il
Subject: Re: RAID 10 or RAID 10 + RAID 1
In-Reply-To: <20070814213150.GT54135@nasby.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