X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3476BD843C for ; Tue, 30 Aug 2005 09:58:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49832-10 for ; Tue, 30 Aug 2005 12:58:21 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id 9939FD8471 for ; Tue, 30 Aug 2005 09:58:19 -0300 (ADT) Received: (qmail 24048 invoked by uid 500); 30 Aug 2005 12:58:08 -0000 Date: Tue, 30 Aug 2005 07:58:08 -0500 From: Bruno Wolff III To: Alvaro Nunes Melo Cc: PostgreSQL - Performance Subject: Re: RAID Configuration Sugestion Message-ID: <20050830125808.GD22545@wolff.to> Mail-Followup-To: Bruno Wolff III , Alvaro Nunes Melo , PostgreSQL - Performance References: <431452FD.3090402@atua.com.br> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <431452FD.3090402@atua.com.br> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/512 X-Sequence-Number: 14259 On Tue, Aug 30, 2005 at 09:37:17 -0300, Alvaro Nunes Melo wrote: > > 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? You don't have a lot of options with just two disks. What are you trying to accomplish with raid? Raid 0 will possibly give you some speed up, while raid 1 will give you some fault tolerance, some speed of of reads, but cost you half your disk space.