X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3B483475D0D for ; Fri, 14 Feb 2003 10:05:42 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id CBEF4475D17 for ; Fri, 14 Feb 2003 10:05:40 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1EF5i5u007028; Fri, 14 Feb 2003 10:05:45 -0500 (EST) To: Kevin Brown Cc: pgsql-performance@postgresql.org Subject: Re: Tuning scenarios (was Changing the default configuration) In-reply-to: <20030214114843.GB1847@filer> 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> <20030214053124.GQ1833@filer> <4590.1045202674@sss.pgh.pa.us> <20030214114843.GB1847@filer> Comments: In-reply-to Kevin Brown message dated "Fri, 14 Feb 2003 03:48:43 -0800" Date: Fri, 14 Feb 2003 10:05:44 -0500 Message-ID: <7027.1045235144@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/80 X-Sequence-Number: 1136 Kevin Brown writes: > Tom Lane wrote: >> ... But those same >> limitations cause the results to be unstable from run to run, which >> is why I don't have a lot of faith in reports of pgbench numbers. >> You need to work quite hard to get reproducible numbers out of it. > The interesting question is whether that's more an indictment of how > PG does things or how pg_bench does things. I didn't draw a conclusion on that ;-). I merely pointed out that the numbers are unstable, and therefore not to be trusted without a great deal of context ... regards, tom lane