Best way to load test a postgresql server

From: "Peter Sheats" <psheats(at)pbpost(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Best way to load test a postgresql server
Date: 2009-06-01 15:55:53
Message-ID: C6497249.20452%psheats@pbpost.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Koen Martens 2009-06-01 16:02:09 Very inefficient query plan with disjunction in WHERE clause
Previous Message Shaul Dar 2009-06-01 15:46:22 Using index for bitwise operations?