Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 4A84B633E99
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 10 Apr 2009 21:03:45 -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 51661-01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 10 Apr 2009 21:03:32 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-qy0-f115.google.com (mail-qy0-f115.google.com
	[209.85.221.115])
	by mail.postgresql.org (Postfix) with ESMTP id 30043632FD0
	for <pgsql-performance@postgresql.org>;
	Fri, 10 Apr 2009 21:03:39 -0300 (ADT)
Received: by qyk13 with SMTP id 13so2251931qyk.15
	for <pgsql-performance@postgresql.org>;
	Fri, 10 Apr 2009 17:03:37 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:content-type;
	bh=QyVpFDknxRbQtN+OlOIhnp8hPkGj9Z0Z/pWvqf4czd8=;
	b=XHimZ4y8vEquxZ05MuBK1u+xLWP1JuiI2vj8F/9S2MbCHuN9BmJg8g4xEmsh+gPVRI
	lMTkmly20yd14/FXX+Bce9jXDkj4MKHfeX7yiCTl8lG8sCLvYv0WPW07aI3FWdMdyPIF
	SAhoESL/ekos51UCtFKzpSvyDb4LZk8bnY7Rk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:content-type;
	b=l2F8piwKG8aZmzl4CxfoPyMdAvdBcn3j7CjO3rC1rdx5WJfVydSOx6Ldbzr4eaGO0K
	YIrh9poURCIa2GVEeUC1gIOQOlAO7/Og/TaX8k/ywKxojKTjK4mk483yVWMsIP6oY5Rq
	l+Wi+3KNTUroFvvWP9eetBz33tPYQ8CgCUZO4=
MIME-Version: 1.0
Received: by 10.220.97.146 with SMTP id l18mr5344760vcn.77.1239408217781;
 Fri,
	10 Apr 2009 17:03:37 -0700 (PDT)
In-Reply-To: <alpine.GSO.2.01.0904101524110.10958@westnet.com>
References: <C604DB53.4877%scott@richrelevance.com>
	<alpine.GSO.2.01.0904101524110.10958@westnet.com>
Date: Fri, 10 Apr 2009 17:03:37 -0700
Message-ID: <af0420cd0904101703k3a150bd6o35ff2b8c7dc812de@mail.gmail.com>
Subject: Re: Using IOZone to simulate DB access patterns
From: "M. Edward (Ed) Borasky" <zznmeb@gmail.com>
To: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=0016e64716968d765804673c36ac
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL=-0.001,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200904/214
X-Sequence-Number: 33581

--0016e64716968d765804673c36ac
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

I've done quite a bit with IOzone, but if you're on Linux, you have lots of
options. In particular, you can actually capture I/O patterns from a running
application with blktrace, and then replay them with btrecord / btreplay.

The documentation for this stuff is a bit hard to find. Some of the distros
don't install it by default. But have a look at

http://ow.ly/2zyW

for some "Getting Started" info.
-- 
M. Edward (Ed) Borasky
http://www.linkedin.com/in/edborasky

I've never met a happy clam. In fact, most of them were pretty steamed.

--0016e64716968d765804673c36ac
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

I&#39;ve done quite a bit with IOzone, but if you&#39;re on Linux, you have lots of options. In particular, you can actually capture I/O patterns from a running application with blktrace, and then replay them with btrecord / btreplay. <br>
<br>The documentation for this stuff is a bit hard to find. Some of the distros don&#39;t install it by default. But have a look at<br><br><a href="http://ow.ly/2zyW">http://ow.ly/2zyW</a><br><br>for some &quot;Getting Started&quot; info.<br>
-- <br>M. Edward (Ed) Borasky<br><a href="http://www.linkedin.com/in/edborasky">http://www.linkedin.com/in/edborasky</a><br><br>I&#39;ve never met a happy clam. In fact, most of them were pretty steamed.<br>

--0016e64716968d765804673c36ac--