X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5EB414759AF for ; Wed, 19 Feb 2003 10:13:58 -0500 (EST) Received: from grunt25.ihug.com.au (grunt25.ihug.com.au [203.109.249.145]) by postgresql.org (Postfix) with ESMTP id 84D96475843 for ; Wed, 19 Feb 2003 10:13:57 -0500 (EST) Received: from p52-tnt2.adl.ihug.com.au (postgresql.org) [203.173.252.52] by grunt25.ihug.com.au with esmtp (Exim 3.35 #1 (Debian)) id 18lVuz-000513-00; Thu, 20 Feb 2003 02:13:54 +1100 Message-ID: <3E539F8D.7040406@postgresql.org> Date: Thu, 20 Feb 2003 01:45:25 +1030 From: Justin Clift User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Josh Berkus , kbottner@istation.com, pgsql-performance@postgresql.org Subject: Re: Performance Baseline Script References: <11199.1045667021@sss.pgh.pa.us> In-Reply-To: <11199.1045667021@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/129 X-Sequence-Number: 1185 Tom Lane wrote: > "Josh Berkus" writes: > >>Keith, >> >>>Does there currently exist any kind of script that can be run on >>>Postgres to conduct a complete feature coverage test with varying >>>dataset sizes to compare performance between functionality changes? > >>No. > > If you squint properly, OSDB (http://osdb.sourceforge.net/) might be > thought to do this, or at least be a starting point for it. As a side thought, just today found out that the TPC organisation provides all kinds of code freely for building/running the TPC-x tests. Didn't know that before. Sure, we can't submit results yet, but we might at least be able to run the tests and see if anything interesting turns up. People have talked about the TPC tests before, but not sure if anyone has really looked at making them runnable on PostgreSQL for everyone yet. Regards and best wishes, Justin Clift > regards, tom lane -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi