Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 41FC59FB656 for ; Wed, 10 Oct 2007 19:22:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 90726-08 for ; Wed, 10 Oct 2007 19:22:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outbound-mail-31.bluehost.com (outbound-mail-31.bluehost.com [69.89.18.151]) by postgresql.org (Postfix) with SMTP id C1DF19FB615 for ; Wed, 10 Oct 2007 19:22:14 -0300 (ADT) Received: (qmail 14340 invoked by uid 0); 10 Oct 2007 22:22:12 -0000 Received: from unknown (HELO box54.bluehost.com) (69.89.20.54) by mailproxy2.bluehost.com with SMTP; 10 Oct 2007 22:22:12 -0000 Received: from corp.messageone.com ([66.219.55.2] helo=ematt.austin.messageone.com) by box54.bluehost.com with esmtp (Exim 4.68) (envelope-from ) id 1IfjwR-0007re-W0 for pgsql-performance@postgresql.org; Wed, 10 Oct 2007 16:22:12 -0600 From: Kevin Kempter To: pgsql-performance@postgresql.org Subject: building a performance test suite Date: Wed, 10 Oct 2007 16:21:41 -0600 User-Agent: KMail/1.9.7 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200710101621.41749.kevin@kevinkempterllc.com> X-Identified-User: {840:box54.bluehost.com:kevinkem:kevinkempterllc.com} {sentby:bopbeforesmtp 66.219.55.2 authed with kevinkempterllc.com} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/118 X-Sequence-Number: 27140 Hi List; I'm preparing to create a test suite of very complex queries that can be profiled in terms of load and performance. The ultimate goal is to define a load/performance profile during a run of the old application code base and then again with changes to the application code base. I suspect I should look at grabbing these things for load: # of queries running # of IDLE connections and these things for performance how long the queries run difference between the runs for # of queries running What do you'all think? are these valid metrics? should I be looking at others like pg_statio or pg_stat_all_tables ? If so, what should I look for in these (or other) tables? Thanks in advance... /Kevin