From: Dimitri Fontaine <dim@dalibo.com>
Organization: dalibo
To: pgsql-performance@postgresql.org
Subject: Re: Easy read-heavy benchmark kicking around?
Date: Tue, 7 Nov 2006 11:49:05 +0100
User-Agent: KMail/1.9.5
References: <20061102160057.GA26580@oppetid.no>
	<454F9F62.9070408@janestcapital.com>
In-Reply-To: <454F9F62.9070408@janestcapital.com>
MIME-Version: 1.0
Content-Type: multipart/signed; boundary="nextPart14913813.DM7pmAy4zv";
	protocol="application/pgp-signature"; micalg=pgp-sha1
Content-Transfer-Encoding: 7bit
Message-Id: <200611071149.07756.dim@dalibo.com>

--nextPart14913813.DM7pmAy4zv
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,

Le lundi 6 novembre 2006 21:47, Brian Hurt a =E9crit=A0:
> 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=
=20
tool. The more simple way to use it to stress test your machine would be=20
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 playi=
ng=20
your custom defined load scenario. Then it will give you some plots to=20
analyze results, for disk io though you'll have to use some other tool(s)=20
while tests are running.

Regards,
=2D-=20
Dimitri Fontaine
http://www.dalibo.com/

--nextPart14913813.DM7pmAy4zv
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQBFUGSjl4JX7QVNfwQRArkiAJ0QL35sDmE89j6/boNVyyOabhA8jwCfRYnZ
auxxeBnRoCsAMYyCyWlR+Cg=
=Tedh
-----END PGP SIGNATURE-----

--nextPart14913813.DM7pmAy4zv--