Best way to load test a postgresql server

["Peter Sheats" <psheats@xxxxxxxxxx>]

Title: Best way to load test a postgresql server

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