Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id CA6271337B67 for ; Tue, 10 May 2011 03:59:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 20854-08 for ; Tue, 10 May 2011 06:58:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ey0-f174.google.com (mail-ey0-f174.google.com [209.85.215.174]) by mail.postgresql.org (Postfix) with ESMTP id E11BE1337990 for ; Tue, 10 May 2011 03:58:44 -0300 (ADT) Received: by eyx24 with SMTP id 24so1743532eyx.19 for ; Mon, 09 May 2011 23:58:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:message-id:date:from:user-agent:mime-version:to :cc:subject:references:in-reply-to:content-type :content-transfer-encoding; bh=NTWQ4+hoSFqLJKq2y+isDYD5Q4VJEQ8MuDBh3qCTtcA=; b=JVrYkqvb5oVXlzemW3qCYDuEP0vSd/E7riVzU7x7f/ilD8ncavfM1mNNJ42/dLH0vk zI31wi6QzMXPPJs13g0QIfecEqOTEFHSRJKaHDpDFHzFj1/LgbjJc3YnRHoC/2hFanPF WH2fIcgH/cIs+3+36GNqxFkwtE0sfl2JSrP7c= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=sXPz3yUAm/Sv8tsotAnGRBichk/y3mKdTus6cSJKtSctsgw2UfIHxlk2OoRSypVDov Psubtq98bB5IODse3nYUTMlGeUNkQ5wvlf5B+MYdbBzE3985j2iDkxTm6kBSzValiEbL pY53+Upt277eVllKSIFSvWaAnAbF8JboT755A= Received: by 10.14.119.1 with SMTP id m1mr3602700eeh.44.1305010723847; Mon, 09 May 2011 23:58:43 -0700 (PDT) Received: from [0.0.0.0] (5357DA75.cm-6-8d.dynamic.ziggo.nl [83.87.218.117]) by mx.google.com with ESMTPS id x5sm4075701eea.0.2011.05.09.23.58.41 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 09 May 2011 23:58:42 -0700 (PDT) Message-ID: <4DC8E20D.7090602@gmail.com> Date: Tue, 10 May 2011 08:58:21 +0200 From: Yeb Havinga User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.2.17) Gecko/20110414 Lightning/1.0b2 Thunderbird/3.1.10 MIME-Version: 1.0 To: Chris Hoover CC: PGSQL Performance Subject: Re: Benchmarking a large server 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=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201105/117 X-Sequence-Number: 43626 On 2011-05-09 22:32, Chris Hoover wrote: > > The issue we are running into is how do we benchmark this server, > specifically, how do we get valid benchmarks for the Fusion IO card? > Normally to eliminate the cache effect, you run iozone and other > benchmark suites at 2x the ram. However, we can't do that due to 2TB > > 1.3TB. > > So, does anyone have any suggestions/experiences in benchmarking > storage when the storage is smaller then 2x memory? Oracle's Orion test tool has a configurable cache size parameter - it's a separate download and specifically written to benchmark database oltp and olap like io patterns, see http://www.oracle.com/technetwork/topics/index-089595.html -- Yeb Havinga http://www.mgrid.net/ Mastering Medical Data