X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3993652933 for ; Thu, 23 Jun 2005 10:47:16 -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 45673-03 for ; Thu, 23 Jun 2005 13:47:11 +0000 (GMT) Received: from frank.wiles.org (frank.wiles.org [24.124.39.75]) by svr1.postgresql.org (Postfix) with ESMTP id E421F52862 for ; Thu, 23 Jun 2005 10:47:10 -0300 (ADT) Received: from kungfu (frank.wiles.org [127.0.0.1]) by frank.wiles.org (8.13.1/8.13.1) with SMTP id j5NDowIj030666; Thu, 23 Jun 2005 08:50:58 -0500 Date: Thu, 23 Jun 2005 08:48:54 -0500 From: Frank Wiles To: KeithW@NarrowPathInc.com Cc: pgsql-performance@postgresql.org Subject: Re: Performance Tuning Article Message-Id: <20050623084854.0776d7a7.frank@wiles.org> In-Reply-To: <42BA1F01.1010700@NarrowPathInc.com> References: <20050622095227.05938982.frank@wiles.org> <200506221016.03808.josh@agliodbs.com> <20050622124232.71b05e3f.frank@wiles.org> <42BA1F01.1010700@NarrowPathInc.com> X-Mailer: Sylpheed version 1.0.4 (GTK+ 1.2.10; i386-redhat-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/453 X-Sequence-Number: 13090 On Wed, 22 Jun 2005 22:31:29 -0400 Keith Worthington wrote: > Frank, > > A couple of things I wish I had been told when I started asking how to > > configure a new machine. > > Use RAID 10 (striping across mirrored disks) > or RAID 0+1 (mirror a striped array) for your data. > Use RAID 1 (mirror) for your OS > Use RAID 1 (mirror) for the WAL. > > Don't put anything else on the array holding the WAL. > > There have been problems with Xeon processors. I believe all of these issues are covered in the article, but obviously not clearly enough. I'll work on rewording that section. --------------------------------- Frank Wiles http://www.wiles.org ---------------------------------