Good afternoon!
I'm Lily Anne Sanchez, a database engineer here at Ameritrade Holdings,
Inc. I'm currently in charge of an initiative to evaluate postgresSQL
for an eventual migration from Oracle and other enterprise rdbms. As
part of our generic testing (benchmarking) phase, we are in the process
of writing a java test harness that will do the following:
- connect to any db specified in a config file via JDBC (and ODBC)
- generate multiple connections, as specified in a config file, running
on different threads
- run a cobination of SQL select, insert, update, delete, sp statements,
as specified in a config file
- measure the throughput and outputs to a file that could be imported to
a table for further analysis
I was advised by Bruce Momjian to send you guys an email to see whether
you've already done something like this, so as to compare our results
and/or minimize the effort that we will need to do to complete this
phase.
Any help or advise that you could extend will be greatly appreciated.
Thanks so much!
Regards,
- Lily Anne Sanchez
201.761.5905