Re: Best way to load test a postgresql server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 02 Jun 2009 05:26:41 -0400, Dimitri Fontaine <dfontaine@xxxxxxxxxxxx> 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

--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux