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. 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
<psheats@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