Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6B03F632179 for ; Sat, 4 Apr 2009 07:49:54 -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 63956-09 for ; Sat, 4 Apr 2009 07:49:52 -0300 (ADT) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by mail.postgresql.org (Postfix) with ESMTP id 2FBB7631E2D for ; Sat, 4 Apr 2009 07:49:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from shrek.krogh.cc (2605ds1-ynoe.1.fullrate.dk [90.184.12.24]) by mx3.hub.org (Postfix) with ESMTP id 75DC137B522 for ; Sat, 4 Apr 2009 07:49:51 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by shrek.krogh.cc (Postfix) with ESMTP id 4D9D03BEFED; Sat, 4 Apr 2009 12:49:47 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at shrek.krogh.cc Received: from shrek.krogh.cc ([127.0.0.1]) by localhost (shrek.krogh.cc [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id nFcv9iVU5Ydo; Sat, 4 Apr 2009 12:49:36 +0200 (CEST) Received: from [192.168.1.4] (unknown [90.184.13.46]) by shrek.krogh.cc (Postfix) with ESMTP id E5B963BEEAE; Sat, 4 Apr 2009 12:49:36 +0200 (CEST) Message-ID: <49D73B50.1010007@krogh.cc> Date: Sat, 04 Apr 2009 12:49:52 +0200 From: Jesper Krogh User-Agent: Thunderbird 2.0.0.21 (X11/20090318) MIME-Version: 1.0 To: henk de wit CC: pgsql-performance@postgresql.org, josh@agliodbs.com Subject: Re: Using IOZone to simulate DB access patterns References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/97 X-Sequence-Number: 33464 henk de wit wrote: >> I've been using Bonnie++ for ages to do filesystem testing of new DB servers. But Josh Drake recently turned me on to IOZone. > > Perhaps a little off-topic here, but I'm assuming you are using Linux to > test your DB server (since you mention Bonnie++). But it seems to me > that IOZone only has a win32 client. How did you actually run IOZone on > Linux? $ apt-cache search iozone iozone3 - Filesystem and Disk Benchmarking Tool -- Jesper