Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 73B846329A2 for ; Thu, 2 Apr 2009 03:19:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 66405-03 for ; Thu, 2 Apr 2009 03:19:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp3.clear.net.nz (smtp3.clear.net.nz [203.97.33.64]) by mail.postgresql.org (Postfix) with ESMTP id 0C1B5632943 for ; Thu, 2 Apr 2009 03:19:24 -0300 (ADT) Received: from zmori.markir.net (121-73-181-246.dsl.telstraclear.net [121.73.181.246]) by smtp3.clear.net.nz (CLEAR Net Mail) with ESMTP id <0KHG00HJ3MW5V510@smtp3.clear.net.nz> for pgsql-performance@postgresql.org; Thu, 02 Apr 2009 19:19:17 +1300 (NZDT) Date: Thu, 02 Apr 2009 19:19:17 +1300 From: Mark Kirkwood Subject: Re: Raid 10 chunksize In-reply-to: <49D37CAA.6080100@ummon.com> To: Stef Telford Cc: Scott Carey , "pgsql-performance@postgresql.org" Message-id: <49D458E5.6040107@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: <49D31E85.8050405@paradise.net.nz> <49D37CAA.6080100@ummon.com> User-Agent: Thunderbird 2.0.0.19 (X11/20090117) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200904/38 X-Sequence-Number: 33405 Stef Telford wrote: > > Hello Mark, > For the record, this is a 'base' debian 5 install (with openVZ but > postgreSQL is running on the base hardware, not inside a container) > and I have -explicitly- enabled sync in the conf. Eg; > > > fsync = on # turns forced > > > Infact, if I turn -off- sync commit, it gets about 200 -slower- > rather than faster. > Sorry Stef - didn't mean to doubt you....merely your disks! Cheers Mark