From: Dimitri Fontaine <dim@dalibo.com>
To: pgsql-performance@postgresql.org
Subject: Re: Easy read-heavy benchmark kicking around?
Date: Tue, 7 Nov 2006 11:49:05 +0100
Message-ID: <200611071149.07756.dim@dalibo.com> (raw)
In-Reply-To: <454F9F62.9070408@janestcapital.com>
References: <20061102160057.GA26580@oppetid.no>
<454F9F62.9070408@janestcapital.com>
Hi,
Le lundi 6 novembre 2006 21:47, Brian Hurt a écrit :
> So the question is: is there an easy to install and run, read-heavy
> benchmark out there that I can wave at them to get them to fix the
> problem? I have a second database running on a single SATA drive, so I
> can use that as a comparison point- "look, we're getting 1/3rd the read
> speed of a single SATA drive- this sucks!"
>
> Any advice?
Tsung is an easy to use open-source multi-protocol distributed load testing
tool. The more simple way to use it to stress test your machine would be
using pgfouine to setup a test from postgresql logs:
http://tsung.erlang-projects.org/http://pgfouine.projects.postgresql.org/tsung.html
Tsung will easily simulate a lot (more than 1000) of concurrent users playing
your custom defined load scenario. Then it will give you some plots to
analyze results, for disk io though you'll have to use some other tool(s)
while tests are running.
Regards,
--
Dimitri Fontaine
http://www.dalibo.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dim@dalibo.com
Subject: Re: Easy read-heavy benchmark kicking around?
In-Reply-To: <200611071149.07756.dim@dalibo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox