Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id AFC389F9B7A for ; Tue, 14 Aug 2007 07:21:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 64514-07 for ; Tue, 14 Aug 2007 07:21:31 -0300 (ADT) X-Greylist: delayed 00:06:53.504106 by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.250]) by postgresql.org (Postfix) with ESMTP id 739369F9997 for ; Tue, 14 Aug 2007 07:21:35 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so283208ana for ; Tue, 14 Aug 2007 03:21:34 -0700 (PDT) Received: by 10.100.44.13 with SMTP id r13mr5728137anr.1187086479784; Tue, 14 Aug 2007 03:14:39 -0700 (PDT) Received: by 10.100.95.11 with HTTP; Tue, 14 Aug 2007 03:14:39 -0700 (PDT) Message-ID: Date: Tue, 14 Aug 2007 13:14:39 +0300 From: "Michael Ben-Nes" To: "PostgreSQL Performance" Subject: RAID 10 or RAID 10 + RAID 1 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_50104_30690939.1187086479749" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/150 X-Sequence-Number: 26280 ------=_Part_50104_30690939.1187086479749 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ) What is the recommended stripe size ( The computer is Dell PowerEdge 2950 ) Thanks, Miki -- -------------------------------------------------- Michael Ben-Nes - Internet Consultant and Director. http://www.epoch.co.il - weaving the Net. Cellular: 054-4848113 -------------------------------------------------- ------=_Part_50104_30690939.1187086479749 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 )

What is the recommended stripe size ( The computer is Dell PowerEdge 2950 )

Thanks,
Miki

--
--------------------------------------------------
Michael Ben-Nes - Internet Consultant and  Director.
http://www.epoch.co.il - weaving the Net.
Cellular: 054-4848113
-------------------------------------------------- ------=_Part_50104_30690939.1187086479749--