Re: Best way to load test a postgresql server

On Tue, 02 Jun 2009 05:26:41 -0400, Dimitri Fontaine
<dfontaine(at)hi-media(dot)com> wrote:
> I'd recommand having a look at tsung which will be able to replay a
> typical application scenario with as many concurrent users as you want
> to: http://archives.postgresql.org/pgsql-admin/2008-12/msg00032.php
> http://tsung.erlang-projects.org/
> http://pgfouine.projects.postgresql.org/tsung.html

I am having a look at tsung and not getting very far yet. Have you had
luck with it and do you really mean as many concurrent users as you want?
I was hoping to use it to simulate my current load while tuning and making
improvements. So far tsung doesn't appear well suited to my needs. I use
persistent connections; each tsung session uses a new connection. I have
multiple applications that have very usage patterns (some web and largely
idle, some non web and almost saturated); tsung has virtual users choosing
a session based on a probability with think times. I know many
programming languages; tsung (and its error messages) is in erlang.

> If you want to replay your logs at the current production speed and
> concurrency, see Playr.
> https://area51.myyearbook.com/trac.cgi/wiki/Playr

Thanks for this tip. It seems worth a look.

Regards,
Ken