X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C41CA474E4F for ; Fri, 14 Feb 2003 00:31:21 -0500 (EST) Received: from filer (12-234-86-219.client.attbi.com [12.234.86.219]) by postgresql.org (Postfix) with ESMTP id 56E6A474E42 for ; Fri, 14 Feb 2003 00:31:19 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) (uid 1000) by filer with local; Thu, 13 Feb 2003 21:31:24 -0800 Date: Thu, 13 Feb 2003 21:31:24 -0800 From: Kevin Brown To: pgsql-performance@postgresql.org Subject: Tuning scenarios (was Changing the default configuration) Message-ID: <20030214053124.GQ1833@filer> Mail-Followup-To: Kevin Brown , pgsql-performance@postgresql.org References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <26004.1044980414@sss.pgh.pa.us> <3E492E06.2030702@postgresql.org> <200302110918.48614.josh@agliodbs.com> <26582.1044984365@sss.pgh.pa.us> <3E493415.9090004@postgresql.org> <26850.1044985975@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: <26850.1044985975@sss.pgh.pa.us> User-Agent: Mutt/1.4i Organization: Frobozzco International X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/74 X-Sequence-Number: 1130 Tom Lane wrote: > If I thought that pgbench was representative of anything, or even > capable of reliably producing repeatable numbers, then I might subscribe > to results derived this way. But I have little or no confidence in > pgbench. Certainly I don't see how you'd use it to produce > recommendations for a range of application scenarios, when it's only > one very narrow scenario itself. So let's say you were designing a tool to help someone get reasonable performance out of a PostgreSQL installation. What scenarios would you include in such a tool, and what information would you want out of it? You don't have any real confidence in pgbench. Fair enough. What *would* you have confidence in? -- Kevin Brown kevin@sysexperts.com