Re: Best way to load test a postgresql server

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 <psheats(at)pbpost(dot)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
>