X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D392DD1B4ED for ; Wed, 12 Nov 2003 22:29:59 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 81605-07 for ; Wed, 12 Nov 2003 18:29:31 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id 29DCED1B50C for ; Wed, 12 Nov 2003 18:29:29 -0400 (AST) Received: from tokyo.samurai.com (d226-89-59.home.cgocable.net [24.226.89.59]) by bob.samurai.com (Postfix) with ESMTP id B52BF1FC7; Wed, 12 Nov 2003 17:29:30 -0500 (EST) To: Suchandra Thapa Cc: pgsql-performance@postgresql.org Subject: Re: performance optimzations From: Neil Conway In-Reply-To: <1068658430.1071.42.camel@hepcat> (Suchandra Thapa's message of "12 Nov 2003 11:34:41 -0600") References: <1068658430.1071.42.camel@hepcat> Date: Wed, 12 Nov 2003 17:29:30 -0500 Message-ID: <87oevh9q5x.fsf@mailbox.samurai.com> User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/77 X-Sequence-Number: 4637 Suchandra Thapa writes: > I was thinking using about using a raid 1+0 array to hold the > database but since I can use different array types, would it be > better to use 1+0 for the wal logs and a raid 5 for the database? It has been recommended on this list that getting a RAID controller with a battery-backed cache is pretty essential to getting good performance. Search the list archives for lots more discussion about RAID configurations. -Neil