X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 32324475925 for ; Tue, 18 Feb 2003 14:48:19 -0500 (EST) Received: from hal.istation.com (hal.istation.com [65.120.151.132]) by postgresql.org (Postfix) with ESMTP id B51C147592C for ; Tue, 18 Feb 2003 14:48:18 -0500 (EST) Received: from sauron (sauron.istation.com [65.120.151.174]) (authenticated) by hal.istation.com (8.11.6/8.11.6) with ESMTP id h1IJmHE20528 for ; Tue, 18 Feb 2003 13:48:17 -0600 Reply-To: From: "Keith Bottner" To: Subject: Performance Baseline Script Date: Tue, 18 Feb 2003 13:48:19 -0600 Organization: istation.com Message-ID: <001601c2d786$afd50d00$ae977841@istation.com> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 In-reply-to: <200302180937.21001.josh@agliodbs.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/117 X-Sequence-Number: 1173 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? The interest of course is to get a baseline of performance and then to see how manipulation of internal algorithms or vacuum frequency or WAL logs being place on a separate physical disk affect the performance of the various features with various dataset sizes. If not, how many people would be interested in such a script being written? Keith Bottner kbottner@istation.com "Vegetarian - that's an old Indian word meaning 'lousy hunter.'" - Andy Rooney