Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 0486B133740B for ; Mon, 9 May 2011 17:59:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 76323-02 for ; Mon, 9 May 2011 20:59:05 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from skunk.mtbrook.bozemanpass.com (skunk.mtbrook.bozemanpass.com [69.145.82.195]) by mail.postgresql.org (Postfix) with ESMTP id 6FB6B133616B for ; Mon, 9 May 2011 17:59:04 -0300 (ADT) Received: from [69.145.82.248] (unknown [69.145.82.248]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by skunk.mtbrook.bozemanpass.com (Postfix) with ESMTP id 66270558039 for ; Mon, 9 May 2011 13:59:02 -0700 (PDT) Message-ID: <4DC85595.5070909@boreham.org> Date: Mon, 09 May 2011 14:59:01 -0600 From: David Boreham User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10 MIME-Version: 1.0 To: 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.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201105/86 X-Sequence-Number: 43595 > hm, if it was me, I'd write a small C program that just jumped > directly on the device around and did random writes assuming it wasn't > formatted. For sequential read, just flush caches and dd the device > to /dev/null. Probably someone will suggest better tools though. I have a program I wrote years ago for a purpose like this. One of the things it can do is write to the filesystem at the same time as dirtying pages in a large shared or non-shared memory region. The idea was to emulate the behavior of a database reasonably accurately. Something like bonnie++ would probably be a good starting point these days though.