Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 4ED0D634C85
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  8 Mar 2010 10:56:15 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 38433-01-10
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  8 Mar 2010 14:55:55 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ew0-f227.google.com (mail-ew0-f227.google.com
	[209.85.219.227])
	by mail.postgresql.org (Postfix) with ESMTP id 314E06330D1
	for <pgsql-performance@postgresql.org>;
	Mon,  8 Mar 2010 10:55:58 -0400 (AST)
Received: by ewy27 with SMTP id 27so2666611ewy.34
	for <pgsql-performance@postgresql.org>;
	Mon, 08 Mar 2010 06:55:56 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from
	:user-agent:mime-version:to:cc:subject:references:in-reply-to
	:content-type:content-transfer-encoding;
	bh=jOIX7/u5mtMUDFRJEhUkKoM8bXfwJOWYIfND8fygO7c=;
	b=xch3momvyonTnNU0sQT40zVscH3QuMrUTl7QAz/jrtOVL6B7giW45MEUVTEjIHDxSl
	hfYUqBNFpBpdAD/O2N1MvjMn+1avcxnUhYCanNe/kKXpaOHkfrrLYals5YszjZMuSSwa
	53cvoLW3d9bkpxtot8jvbmNuKdv9ouN/v2pEU=
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=I9cRg/XaY15LtwhyesGJk6D7xmjhnjt1mv/5v4MlJdKeohgOksL8/faDi9xSRzclGJ
	HqCPch5ZrPBW+07sh1t7KbOjYvPya25aKIQyaPJV8w1tGiMXd3HIfChj1hjHz5CM+QFd
	sqWGnvSmBib0R14ISIhzHimgJapdy565WZbT4=
Received: by 10.213.1.145 with SMTP id 17mr3048005ebf.46.1268060155870;
	Mon, 08 Mar 2010 06:55:55 -0800 (PST)
Received: from [0.0.0.0] (5357DA75.cable.casema.nl [83.87.218.117])
	by mx.google.com with ESMTPS id 28sm1358518eye.5.2010.03.08.06.55.55
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Mon, 08 Mar 2010 06:55:55 -0800 (PST)
Message-ID: <4B950FF8.9090206@gmail.com>
Date: Mon, 08 Mar 2010 15:55:52 +0100
From: Yeb Havinga <yebhavinga@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
To: =?UTF-8?B?RGV2cmltIEfDnE5Ew5xa?= <devrim@gunduz.org>
CC: PostgreSQL - Performance <pgsql-performance@postgresql.org>
Subject: Re: Testing FusionIO
References: <1268059301.2098.87.camel@hp-laptop2.gunduz.org>
In-Reply-To: <1268059301.2098.87.camel@hp-laptop2.gunduz.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.372 tagged_above=-10 required=5 tests=AWL=0.227,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/70
X-Sequence-Number: 37895

Devrim GÜNDÜZ wrote:
> Hi,
>
> I have a FusionIO drive
Cool!!
>  to test for a few days. I already ran iozone and
> bonnie++ against it. Does anyone have more suggestions for it?
>   
Oracle has a tool to test drives specifically for database loads kinds 
called orion - its free software and comes with a good manual. Download 
without registration etc at 
http://www.oracle.com/technology/software/tech/orion/index.html

Quickstart

create file named named 'fusion.lun' with the device name, e.g.
/dev/sda1

Invoke orion tool with something like
<orion binary> -run advanced -testname fusion -num_disks 50 -size_small 
4 -size_large 1024 -type rand -simulate concat -verbose -write 25 
-duration 15 -matrix detailed -cache_size 256

cache size is in MB's but not so important for random io.
num disks doesn't have to match physical disks but it's used by the tool 
to determine how large the test matrix should be. E.g. 1 disk gives a 
small matrix with small number of concurrent io requests. So I set it to 50.

Another idea: pgbench?

regards,
Yeb Havinga