Re: Benchmarking

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: mixo <mixo(at)beth(dot)uniforum(dot)org(dot)za>
Cc: "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Benchmarking
Date: 2003-07-08 08:54:58
Message-ID: 20030708095458.A1703@bacon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 |
+------------------------------+---------------------------------------------+

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Weiping He 2003-07-08 09:47:34 Re: any body using Solaris8 with postgresql 7.3.3
Previous Message nolan 2003-07-08 08:34:13 Re: SQL Functions and plan time