Hi Peter, I was looking for the same recently, and my answer is as follows:
1. If you want to test the *H/W and configuration of your DBMS* then you can use the pgbench tool (which uses a specific built-in DB+schema, following the TPC benchmark). 2. If you want to *load test your own specific DB* then I am unaware of any such tools. I ended up using JMeter with the JDBC connector for Postgresql<http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html>. It took me a while to get it configured and running, but I now think JMeter is excellent. I suggest you use JMeter 2.3.2, as I upgraded to 2.3.3 and it seems to have a bug with JDBC connection to Postgres. -- Shaul On Mon, Jun 1, 2009 at 6:55 PM, Peter Sheats <pshe...@pbpost.com> wrote: > Hi, > > I’m about to set up a large instance on Amazon EC2 to be our DB server. > > Before we switch to using it in production I would like to simulate some > load on it so that I know what it can handle and so that I can make sure I > have the optimal settings in the config file. > > What is the best strategy out there for doing this? Does anyone know of > some resource that talks about doing this? > > Thanks, > > Peter >
