Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id E4192640215 for ; Thu, 26 Mar 2009 03:12:21 -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 16339-02-7 for ; Thu, 26 Mar 2009 03:12:10 -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 772B7638307 for ; Thu, 26 Mar 2009 03:08:31 -0300 (ADT) Received: from zmori.markir.net (121-73-184-99.dsl.telstraclear.net [121.73.184.99]) by smtp3.clear.net.nz (CLEAR Net Mail) with ESMTP id <0KH300117J3ZYT40@smtp3.clear.net.nz> for pgsql-performance@postgresql.org; Thu, 26 Mar 2009 17:28:47 +1300 (NZDT) Date: Thu, 26 Mar 2009 17:28:46 +1300 From: Mark Kirkwood Subject: Re: Raid 10 chunksize In-reply-to: <49C9A314.6050302@paradise.net.nz> To: "pgsql-performance@postgresql.org" Message-id: <49CB047E.3090909@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: <49C98433.5080709@paradise.net.nz> <49C9A314.6050302@paradise.net.nz> 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: 200903/378 X-Sequence-Number: 33300 I wrote: > Scott Marlowe wrote: > >> >> Can you try changing the chunksize on the test box you're testing on >> to see if that helps? >> >> > > Yes - or I am hoping to anyway (part of posting here was to collect > some outside validation for the idea). Thanks for your input! > Rebuilt with 64K chunksize: transaction type: TPC-B (sort of) scaling factor: 100 number of clients: 24 number of transactions per client: 12000 number of transactions actually processed: 288000/288000 tps = 866.512162 (including connections establishing) tps = 866.651320 (excluding connections establishing) So 64K looks quite a bit better. I'll endeavor to try out 256K next week too. Mark