X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D41919FA5F8 for ; Fri, 9 Jun 2006 23:29:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 49916-07 for ; Fri, 9 Jun 2006 23:29:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ausimss.pervasive.com (ausimss.pervasive.com [66.45.103.246]) by postgresql.org (Postfix) with ESMTP id 85D559FA38F for ; Fri, 9 Jun 2006 23:29:05 -0300 (ADT) Received: from ausbayes2.aus.pervasive.com ([172.16.8.6]) by ausimss.pervasive.com with InterScan Messaging Security Suite; Fri, 09 Jun 2006 21:28:54 -0500 Received: from AUSOWA.aus.pervasive.com ([172.16.4.8]) by ausbayes2.aus.pervasive.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 9 Jun 2006 21:28:54 -0500 Received: from ausmailid.aus.pervasive.com ([172.16.4.64]) by AUSOWA.aus.pervasive.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 9 Jun 2006 21:28:05 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: FW: pg_xlog on data partition with BBU RAID Date: Fri, 9 Jun 2006 21:24:47 -0500 Message-ID: <4D27CB1096EF1C408F4BFAB0046EC7B608C241@ausmailid.aus.pervasive.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] pg_xlog on data partition with BBU RAID Thread-Index: AcaMJoyVS8iJwIVhROOh5hfPEg0x7gADn7Tm References: <20060609194116.GD57289@pervasive.com> <200606091709.55745@hal.medialogik.com> From: "Jim Nasby" To: X-OriginalArrivalTime: 10 Jun 2006 02:28:05.0645 (UTC) FILETIME=[814313D0:01C68C35] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/115 X-Sequence-Number: 19472 Forwarding to -performance From: Alan Hodgson [mailto:ahodgson@simkin.ca] On Friday 09 June 2006 12:41, "Jim C. Nasby" = wrote: > Has anyone actually done any testing on this? Specifically, I'm > wondering if the benefit of adding 2 more drives to a RAID10 outweighs > whatever penalties there are to having pg_xlog on that RAID10 with all > the rest of the data. I have an external array with 1GB of write-back cache, and testing on it = before deployment showed no difference under any workload I could = generate=20 between having pg_xlog on a separate RAID-1 or having it share a RAID-10 = with the default tablespace. I left it on the RAID-10, and it has been=20 fine there. We have a very write-heavy workload. --=20 "If a nation expects to be ignorant and free, in a state of = civilization, it expects what never was and never will be." -- Thomas Jefferson