Re: Benchmarking - Mailing list pgsql-general

From Paul Thomas
Subject Re: Benchmarking
Date
Msg-id 20030708095458.A1703@bacon
Whole thread Raw
In response to Benchmarking  (mixo <mixo@beth.uniforum.org.za>)
Responses Re: Benchmarking  (Chris Travers <chris@travelamericas.com>)
List pgsql-general
On 08/07/2003 09:14 mixo wrote:
> How can I benchmark the perfomance of Pg with the following setup:
>  Perl 5.8.0 (perl-DBI, perl-DBI-Pg)
>  postgresql-7.3.2-3
>  apache-2.0.40-21
>  mod_perl-1.99_07-5
>
> I want to compare the perfomance of Pg against that of Mysql using my
> own data.

IMHO, the first thing you should do is configure each database to provide
its optimum performance with your hardware and data. Anything less would
not be a fair comparison.

There are a number of open source web testing tools around. Apache JMeter
is a good one.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: SQL Functions and plan time
Next
From: Weiping He
Date:
Subject: Re: any body using Solaris8 with postgresql 7.3.3