Le vendredi 29 septembre 2006 15:54, Andrew Sullivan a écrit :
> On Fri, Sep 29, 2006 at 07:27:49PM +0530, km wrote:
> > Is there any good benchmark suite for testing postgresql performance?
> I suggest looking at the excellent software provided by OSDL.
You could also take a look at tsung software :
This distributed load testing tool supports pgsql protocol.
You can define some sessions using transactions, requests and think-time, mix
them (preferring session A 80% of the time for example), and then configure
it to launch as many users as wanted on some interval (1 user a second, for
example), during some arrival phases. All this in a XML file.
It supports several client machines participating on the same benchmark test,
and produces some graphic reports to analyze results thereafter.
It also comes with a good documentation.
I've beginning to work on dbt2 testing part, re-using its database schema and
database populating code from Mark Wong (OSDL). The tricky part here is
porting SQL input parameters generator, and trying to have comparable test
I hope to get some usefull results to show soon, including comparing 8.1 and
8.2 versions, for some acceptable value of soon :)
In response to
pgsql-general by date
|Next:||From: Paul B. Anderson||Date: 2006-09-29 17:08:15|
|Subject: Re: Array assignment behavior (was Re: Stored procedure array|
|Previous:||From: rloefgren||Date: 2006-09-29 16:51:09|
|Subject: alter integer field to serial integer primary key|