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