Обсуждение: Benchmarking tools for the Postgres, EDB and Oracle Database

On 4/12/07, Ranjan Sahoo <ranjan_edb@yahoo.com> wrote:
>    I am working on a project for testing the performance of Oracle, EDB, and
> postgres and looking for a OLTP benchmarking tool which can do the
> benchmarking on all these databases. Can anyone please help me on this?

To test all three, you'd have to use one of the following:

- BenchmarkSQL (http://pgfoundry.org/projects/benchmarksql/)
- OpenLink's ODBCBench or JBench (www.openlinksw.com)
- JDBCBench (http://developer.mimer.com/features/feature_16.htm)
- jTPCC (http://jtpcc.sourceforge.net/)

Just to make sure you know, both Oracle and EnterpriseDB restrict
public disclosure of benchmark results.

-- 
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 3rd Floor            | jharris@enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

Jonah H. Harris wrote:
> On 4/12/07, Ranjan Sahoo <ranjan_edb@yahoo.com> wrote:
>>    I am working on a project for testing the performance of Oracle, 
>> EDB, and
>> postgres and looking for a OLTP benchmarking tool which can do the
>> benchmarking on all these databases. Can anyone please help me on this?
> 
> To test all three, you'd have to use one of the following:
> 
> - BenchmarkSQL (http://pgfoundry.org/projects/benchmarksql/)
> - OpenLink's ODBCBench or JBench (www.openlinksw.com)
> - JDBCBench (http://developer.mimer.com/features/feature_16.htm)
> - jTPCC (http://jtpcc.sourceforge.net/)
> 
> Just to make sure you know, both Oracle and EnterpriseDB restrict
> public disclosure of benchmark results.

You are kidding right? EDB wouldn't be so arrogant as to state that they 
are faster than PostgreSQL and then not allow public testing of such as 
argument?

Sincerely,

Joshua D. Drake

-- 
      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

On Thu, 12 Apr 2007, Jonah H. Harris wrote:

> - JDBCBench (http://developer.mimer.com/features/feature_16.htm)

I wouldn't recommend this one unless you've got plenty of time to debug it 
and validate the results.  There are multiple errors in the random number 
generation code, some other bugs I forget the details of right now, and 
the coding on some of the later "optimizations" they throw in are written 
so badly they end up degrading performance with PostgreSQL.

You can find a better version of the random ID functions in the version of 
JDBCBench included in HSQL, http://hsqldb.org/ That's missing some useful 
features Mimer added though, and the HSQL version comes with a funky 
license.  Their version is by no means bug-free either.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

All,

I would recommend the new semi-free version of SpecJAppserver, called 
EAStress.http://www.spec.org/jAppServer2004/

--Josh