Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id DE0106335AF for ; Fri, 10 Apr 2009 14:10:18 -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 70093-03 for ; Fri, 10 Apr 2009 14:10:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136173.authsmtp.com (outmail136173.authsmtp.com [62.13.136.173]) by mail.postgresql.org (Postfix) with ESMTP id 5FF2963342F for ; Fri, 10 Apr 2009 14:10:14 -0300 (ADT) Received: from mail-c188.authsmtp.com (mail-c188.authsmtp.com [62.13.128.25]) by punt6.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n3AHA6PS040324; Fri, 10 Apr 2009 18:10:06 +0100 (BST) Received: from Sidney-Stratton.local (adsl-63-195-55-98.dsl.snfc21.pacbell.net [63.195.55.98]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n3AHA3OO084009; Fri, 10 Apr 2009 18:10:04 +0100 (BST) Message-ID: <49DF7D6B.9020107@agliodbs.com> Date: Fri, 10 Apr 2009 10:10:03 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. 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: Mark Kirkwood CC: henk de wit , jesper@krogh.cc, pgsql-performance@postgresql.org Subject: Re: Using IOZone to simulate DB access patterns References: <49D73B50.1010007@krogh.cc> <49DEDC1B.7080303@agliodbs.com> <49DEE6B2.7030602@paradise.net.nz> In-Reply-To: <49DEE6B2.7030602@paradise.net.nz> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: 6fdb0602-25f2-11de-aecc-001871e930f4 X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQN c1ADdh16KEdbHwkB CnYKU15VUFdxXC1z aBRQZABDZ09QVg11 Uk1LR01SWltrcGRw BWFhUhF2dwVPNn90 Y0csWCYPDkR8dURg QEsCF3AHZDM1dTFK AxNFdwNVeARLKxZG agZ7GhFYa3VsBg8C MSgJGgV5AC5eLisd YyY/KlQfCVoMViU9 Qg0GFCkiVWEvDyw4 JBE9MRYEFVoNP180 KjNh X-Authentic-SMTP: 61633136333939.cat.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-Archive-Number: 200904/196 X-Sequence-Number: 33563 On 4/9/09 11:26 PM, Mark Kirkwood wrote: > Josh Berkus wrote: >> All, >> >> Wow, am I really the only person here who's used IOZone? >> > > No - I used to use it exclusively, but everyone else tended to demand I > redo stuff with bonnie before taking any finding seriously... so I've > kinda 'submitted to the Borg' as it were.... Bonnie++ has its own issues with concurrency; it's using some kind of ad-hoc threading implementation, which results in not getting real parallelism. I just did a test with -c 8 on Bonnie++ 1.95, and the program only ever used 3 cores. -- Josh Berkus PostgreSQL Experts Inc. www.pgexperts.com