X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CE479D1B524 for ; Fri, 15 Aug 2003 06:34:36 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 01272-01 for ; Fri, 15 Aug 2003 03:34:25 -0300 (ADT) Received: from beth.coza.net.za (beth.coza.net.za [206.223.136.193]) by svr1.postgresql.org (Postfix) with ESMTP id 4E117D1C50D for ; Fri, 15 Aug 2003 03:34:21 -0300 (ADT) Received: from coza.net.za (mixo.coza.net.za [206.223.136.225]) by beth.coza.net.za (8.11.6/8.11.2) with ESMTP id h7F6YJo12926 for ; Fri, 15 Aug 2003 08:34:21 +0200 Message-ID: <3F3C7ED5.7050807@coza.net.za> Date: Fri, 15 Aug 2003 08:33:57 +0200 From: mixo Reply-To: mixo@coza.net.za User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3b) Gecko/20030811 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Benchmark Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/271 X-Sequence-Number: 3087 I have the following setup : Apache 2 + mod_perl 2 Postgres 7.3.2 I need to is measure the perfomance of a ticketing system (written in perl) which has web interface (html::mason, apache2) with Pg as a backend. Users of the ticketing system can only connect to the backend via the web interface and they usually login to the system at the begining of the the day and remain connected untill they knock of. I have setup two test machines, one with Pg and the other with Mysql. Both machine have the same data (sample). I am looking for a benchmark utilty that the simulate a user session. For example, a user login in, displaying a ticket and searching for tickets; all these invlove a user connecting to the a url, like for search, a user needs to open "somehost.domain/path/to/search.html?with=arguments". The utiltly needs to simulate these actions. The following tools currently have so far caught my attention: Apache Jmeter ab I need suggestions for other utilities.