Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0FB9E9FA5E4 for ; Thu, 11 Oct 2007 05:52:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 46552-10 for ; Thu, 11 Oct 2007 05:52:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from hi-media.com (9.140-14-84.ripe.coltfrance.com [84.14.140.9]) by postgresql.org (Postfix) with ESMTP id 306C09F9BCF for ; Thu, 11 Oct 2007 05:52:18 -0300 (ADT) Received: from dim (LAubervilliers-151-11-28-79.w193-251.abo.wanadoo.fr [193.251.57.79]) by hi-media.com (Postfix) with ESMTP id 484B21882A5; Thu, 11 Oct 2007 10:48:08 +0200 (CEST) From: Dimitri Fontaine Organization: Hi-Media To: pgsql-performance@postgresql.org Subject: Re: building a performance test suite Date: Thu, 11 Oct 2007 10:52:05 +0200 User-Agent: KMail/1.9.7 Cc: Kevin Kempter References: <200710101621.41749.kevin@kevinkempterllc.com> In-Reply-To: <200710101621.41749.kevin@kevinkempterllc.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart3077337.dE5NioMglg"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200710111052.07722.dfontaine@hi-media.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.044 tagged_above=0 required=5 tests=AWL=-0.057, BAYES_50=0.001, RDNS_DYNAMIC=0.1 X-Spam-Level: X-Archive-Number: 200710/124 X-Sequence-Number: 27146 --nextPart3077337.dE5NioMglg Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, Le jeudi 11 octobre 2007, Kevin Kempter a =E9crit=A0: > I'm preparing to create a test suite of very complex queries that can be > profiled in terms of load and performance. The ultimate goal is to define= a > load/performance profile during a run of the old application code base and > then again with changes to the application code base. You may want to consider using pgfouine and Tsung, the former to create tsu= ng=20 sessions from PostgreSQL logs and the latter to replay them simulating any= =20 number of concurrent users. Tsung can also operate as PostgreSQL proxy recorder, you point your=20 application to it, it forwards the queries and record a session file for yo= u. The replay process can mix several sessions and use several phases of=20 different load behaviours. Then a little helper named tsung-plotter could be useful to draw several Ts= ung=20 results on the same charts for comparing. Some links: http://pgfouine.projects.postgresql.org/tsung.html http://tsung.erlang-projects.org/ http://debian.dalibo.org/sid/tsung-ploter_0.1-1_all.deb http://debian.dalibo.org/sid/tsung-ploter_0.1-1.tar.gz Hope this helps, regards, =2D-=20 dim --nextPart3077337.dE5NioMglg Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBHDeQ3lBXRlnbh1bkRAt55AJ0fpv3Dzj1cFRHVDhRJZtUzD2E9mACgu6Tv PrukBd9hkVZFmUeNqMe8Ga4= =IquH -----END PGP SIGNATURE----- --nextPart3077337.dE5NioMglg--