X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5E04D11F6706 for ; Fri, 14 Apr 2006 02:59:27 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.398 X-Spam-Level: X-Spam-Status: No, score=0.398 required=5 tests=[AWL=0.398] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 4eVNvGf-L3eC for ; Fri, 14 Apr 2006 02:59:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id DCD9C11F670A for ; Fri, 14 Apr 2006 02:59:24 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 5122A56427; Fri, 14 Apr 2006 00:59:24 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Fri, 14 Apr 2006 00:59:23 -0500 Date: Fri, 14 Apr 2006 00:59:23 -0500 From: "Jim C. Nasby" To: Francisco Reyes Cc: Tom Lane , Chris , Pgsql performance Subject: Re: Inserts optimization? Message-ID: <20060414055923.GX49405@pervasive.com> References: <443DA715.4060606@gmail.com> <9549.1144903344@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060414:lists@stringsutils.com::MkIZrL4Il3gObikK:000000000000000 0000000000000000000000002k/j X-Hashcash: 1:20:060414:tgl@sss.pgh.pa.us::zaD2WNEvY9WsUI+M:00000000000000000000 0000000000000000000000003JTD X-Hashcash: 1:20:060414:dmagick@gmail.com::m8DFdG6unaDIConA:00000000000000000000 0000000000000000000000001GxU X-Hashcash: 1:20:060414:pgsql-performance@postgresql.org::ng3hNsvMR40nwp43:00000 0000000000000000000000001hwt X-Archive-Number: 200604/322 X-Sequence-Number: 18406 On Thu, Apr 13, 2006 at 02:59:23PM -0400, Francisco Reyes wrote: > In RAID 10 would it matter that WALL is in the same RAID set? > Would it be better: > 4 disks in RAID10 Data > 2 disks RAID 1 WALL > 2 hot spares Well, benchmark it with your app and find out, but generally speaking unless your database is mostly read you'll see a pretty big benefit to seperating WAL from table/index data. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461