From: Dimitri Fontaine <dfontaine@hi-media.com>
To: pgsql-performance@postgresql.org
Cc: Kevin Kempter <kevin@kevinkempterllc.com>
Subject: Re: building a performance test suite
Date: Thu, 11 Oct 2007 10:52:05 +0200
Message-ID: <200710111052.07722.dfontaine@hi-media.com> (raw)
In-Reply-To: <200710101621.41749.kevin@kevinkempterllc.com>
References: <200710101621.41749.kevin@kevinkempterllc.com>
Hi,
Le jeudi 11 octobre 2007, Kevin Kempter a écrit :
> 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 tsung
sessions from PostgreSQL logs and the latter to replay them simulating any
number of concurrent users.
Tsung can also operate as PostgreSQL proxy recorder, you point your
application to it, it forwards the queries and record a session file for you.
The replay process can mix several sessions and use several phases of
different load behaviours.
Then a little helper named tsung-plotter could be useful to draw several Tsung
results on the same charts for comparing.
Some links:
http://pgfouine.projects.postgresql.org/tsung.htmlhttp://tsung.erlang-projects.org/http://debian.dalibo.org/sid/tsung-ploter_0.1-1_all.debhttp://debian.dalibo.org/sid/tsung-ploter_0.1-1.tar.gz
Hope this helps, regards,
--
dim
Attachments:
signature.asc (application/pgp-signature, 188B) download
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: dfontaine@hi-media.com, kevin@kevinkempterllc.com
Subject: Re: building a performance test suite
In-Reply-To: <200710111052.07722.dfontaine@hi-media.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