Skip site navigation (1) Skip section navigation (2)

Re: benchmark suite

From: Dimitri Fontaine <dim(at)dalibo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: benchmark suite
Date: 2006-09-29 16:58:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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 :)

Dimitri Fontaine

In response to

pgsql-general by date

Next:From: Paul B. AndersonDate: 2006-09-29 17:08:15
Subject: Re: Array assignment behavior (was Re: Stored procedure array
Previous:From: rloefgrenDate: 2006-09-29 16:51:09
Subject: alter integer field to serial integer primary key

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group