Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E8F26636252 for ; Fri, 3 Apr 2009 20:13: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 64049-06 for ; Fri, 3 Apr 2009 20:13:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128173.authsmtp.co.uk (outmail128173.authsmtp.co.uk [62.13.128.173]) by mail.postgresql.org (Postfix) with ESMTP id 93F58634595 for ; Fri, 3 Apr 2009 20:13:00 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt8.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n33NCwl0092939 for ; Sat, 4 Apr 2009 00:12:58 +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 n33NCuQ9018473 for ; Sat, 4 Apr 2009 00:12:57 +0100 (BST) Message-ID: <49D697F7.2040304@agliodbs.com> Date: Fri, 03 Apr 2009 16:12:55 -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: Using IOZone to simulate DB access patterns Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: f7f8ce54-20a4-11de-8a51-002264978518 X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkbIhBDJB8RWB5f NVxfJ1xYPXUEQkpF VCReGBUITgIzDi11 bxUgLUdCYEpOVhVq UEJIQFhXE0tuBQIJ BwAcVhxsdgRHZ3x1 Z0N9Xj4FX0cEBgMc S05VHWkBZilhaGgX HhZfIQsHJQZOYx1F O1RiVXJZNHgPN39h WldrZWpvYWQAeHkM EhcwNlMUTg4qOQw7 QR1KATJnBkwAWiE6 MxFuBnRUFU0aP14p eUMoRU4VKRkJYiwg 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/88 X-Sequence-Number: 33455 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. Thing is, IOZone offers a huge complex series of parameters, so I'd really like to have some idea of how to configure it so its results are applicable to database performance. For example, I have a database which is expected to grow to around 200GB in size, most of which consists of two tables partioned into 0.5GB chunks. Reads and writes are consistent and fairly random. The system has 8 cores. How would you configure IOZone to test a filesystem for this? --Josh Berkus