Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 912D89FA28C for ; Mon, 27 Aug 2007 18:18:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 15374-01-4 for ; Mon, 27 Aug 2007 18:18:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id 24D2E9FB295 for ; Mon, 27 Aug 2007 18:18:08 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id f5so1240072nfh for ; Mon, 27 Aug 2007 14:18:07 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=I17zqg0gBl30CJcUIU6YD12g7w2fG2DVvZ85qbvUf2F3ua5H/WMTuCZBXVEdqNHD/7MEpW7Nv1cirnQIX23j3IJdEUM42/T8gNbiXNiR10XYKZto+TgsbljM4It2jRUC4EVDtY75nrQQFRAmeJzsZC7M0yRsNizrYyYw7PoOXt8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=btoKTgpDGp6Jbt9km79a8Fb2yFADPdtbFs3hrYYJ5NEFPmgZULbJxpnszmQRalPP79zhUQH09kXybncdKlZbF1oQiX/zbaRvNdIyU2s8Zqdco0wX9J0ObM7FJ+ruvlo+JKw7jEcD/E8C7qdmq3vyVZY39MUvZe7S6CVV22iQ68M= Received: by 10.78.183.15 with SMTP id g15mr4320269huf.1188249486155; Mon, 27 Aug 2007 14:18:06 -0700 (PDT) Received: by 10.78.18.9 with HTTP; Mon, 27 Aug 2007 14:18:05 -0700 (PDT) Message-ID: Date: Mon, 27 Aug 2007 17:18:05 -0400 From: "Merlin Moncure" To: Decibel! Subject: Re: asynchronous commit feature Cc: "postgresql performance list" In-Reply-To: <20070827201138.GM54309@nasby.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070827201138.GM54309@nasby.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/327 X-Sequence-Number: 26457 On 8/27/07, Decibel! wrote: > On Thu, Aug 23, 2007 at 09:09:00AM -0400, Merlin Moncure wrote: > > I'm testing the new asynch commit feature on various raid > > configurations and my early findings is that it reduces the impact of > > keeping wal and data on the same volume. I have 10 disks to play > > with, and am finding that it's faster to do a 10 drive raid 10 rather > > than 8 drive raid 10 + two drive wal. > > > > anybody curious about the results, feel free to drop a line. I think > > this will be a popular feature. > > With or without a write cache on the RAID controller? I suspect that for > many systems, a write-caching controller will be very similar in > performance to async commit. I usually only work with mid to high end hardware. The platform I'm testing on is: 10x146gb 15k rpm sas in Dell md1000 2xperc 5/e in active/active (5 drives each controller) 2x146gb 15krpm sas on the backplane perc 5/i (for o/s, wal) in my experience, even with a high end raid controller moving the wal offline is helpful in high activity systems, especially during checkpoints. merlin