Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 72610632E41 for ; Fri, 3 Apr 2009 21:10:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20026-05 for ; Fri, 3 Apr 2009 21:09:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128156.authsmtp.com (outmail128156.authsmtp.com [62.13.128.156]) by mail.postgresql.org (Postfix) with ESMTP id C6867634EB5 for ; Fri, 3 Apr 2009 21:09:58 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt3.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n3409urX054628 for ; Sat, 4 Apr 2009 01:09:56 +0100 (BST) Received: from Sidney-Stratton.local (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n3409sve037271 for ; Sat, 4 Apr 2009 01:09:55 +0100 (BST) Message-ID: <49D6A551.5080001@agliodbs.com> Date: Fri, 03 Apr 2009 17:09:53 -0700 From: Josh Berkus Organization: Aglio Database Solutions User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Using IOZone to simulate DB access patterns References: <49D697F7.2040304@agliodbs.com> In-Reply-To: <49D697F7.2040304@agliodbs.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: ed7c6247-20ac-11de-8a51-002264978518 X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkbIhBDJB8RWB5f NVxfJ1xYPXUEQkpF VCReGBUITgIzDi11 bxUgLUdCYEpOVhVq UUJJS1hXEUtuBQIJ BwAcVhxsdgRHZ3x1 Z0N9Xj4FX0B6fAU7 F05XEm8BZClpbGJR BRRfJAVWdARXfB8U OU1+VSdYfG1WY3t9 R1dpZW5tbGoPdX0F VDsAfxoheWsxMBkG YiVKIC4uG0JNZgIB KBorYkIbVF0QN1g2 OEcsEX4yexYZAQBF BAlVCTNFKkMHXEJl X-Authentic-SMTP: 61633136333939.pelican.dmpriest.net.uk:1378/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. 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/91 X-Sequence-Number: 33458 On 4/3/09 4:12 PM, Josh Berkus wrote: > All, > > I've been using Bonnie++ for ages to do filesystem testing of new DB > servers. But Josh Drake recently turned me on to IOZone. Related to this: is IOZone really multi-threaded? I'm doing a test run right now, and only one CPU is actually active. While there are 6 IOZone processes, most of them are idle. --Josh