Обсуждение: Benchmarking tools for the Postgres, EDB and Oracle Database
<div class="MsoNormal"><font color="blue" face="Bookman Old Style" size="2"><span style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY:'Bookman Old Style'">Hi All</span></font><font color="blue" face="Wingdings" size="2"><span style="FONT-SIZE:10pt; COLOR: blue; FONT-FAMILY: Wingdings">J</span></font><font color="blue" face="Bookman Old Style" size="2"><spanstyle="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Bookman Old Style'"></span></font></div><div class="MsoNormal"><fontcolor="blue" face="Bookman Old Style" size="2"><span style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY:'Bookman Old Style'"> </span></font></div><div class="MsoNormal"><font color="blue" face="Bookman Old Style"size="2"><span style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Bookman Old Style'"> I am working on a projectfor testing the performance of Oracle, EDB, and postgres and looking for a OLTP benchmarking tool which can do thebenchmarking on all these databases. Can anyone please help me on this? </span></font></div><div class="MsoNormal"><fontcolor="blue" face="Bookman Old Style" size="2"><span style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY:'Bookman Old Style'"> </span></font></div><div class="MsoNormal"><font color="blue" face="Bookman Old Style"size="2"><span style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Bookman Old Style'"> Thanks in advance to allfor you kind co-operation. </span></font></div><div class="MsoNormal"><font color="blue" face="Bookman Old Style" size="2"><spanstyle="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Bookman Old Style'"></span></font> </div><div class="MsoNormal"><fontcolor="blue" face="Bookman Old Style" size="2"><span style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY:'Bookman Old Style'">Regards</span></font></div><div class="MsoNormal"><font color="blue" face="Bookman Old Style"size="2"><span style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Bookman Old Style'">Ranjan</span></font></div><p><hrsize="1" /><a href=" http://us.rd.yahoo.com/evt=49981/*http://advision.webevents.yahoo.com/mailbeta/features_spam.html">Sucker-punch spam</a>with award-winning protection.<br /> Try the <a href=" http://us.rd.yahoo.com/evt=49981/*http://advision.webevents.yahoo.com/mailbeta/features_spam.html">free Yahoo! Mail Beta.</a>
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