X-Original-To: pgsql-advocacy@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 80A5D476022; Tue, 29 Apr 2003 00:48:38 -0400 (EDT) Received: from neuromancer.ctlno.com (unknown [208.13.35.90]) by postgresql.org (Postfix) with ESMTP id BEA5D475F26; Tue, 29 Apr 2003 00:48:02 -0400 (EDT) Received: from [192.168.1.10] (ool-4352919e.dyn.optonline.net [67.82.145.158]) by neuromancer.ctlno.com (8.12.6/8.12.6) with ESMTP id h3T5jfkN017013; Tue, 29 Apr 2003 00:45:41 -0500 Subject: Re: [HACKERS] Changing the default configuration From: "Matthew T. O'Connor" To: Tatsuo Ishii Cc: tgl@sss.pgh.pa.us, justin@postgresql.org, josh@agliodbs.com, merlin.moncure@rcsonline.com, pgsql-hackers@postgresql.org, pgsql-advocacy@postgresql.org In-Reply-To: <20030212.101000.74752335.t-ishii@sra.co.jp> References: <26582.1044984365@sss.pgh.pa.us> <3E493415.9090004@postgresql.org> <26850.1044985975@sss.pgh.pa.us> <20030212.101000.74752335.t-ishii@sra.co.jp> Content-Type: text/plain Organization: Zeut Tech Message-Id: <1051591298.7047.11.camel@zeutrh9> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 29 Apr 2003 00:41:38 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Spam-Status: No, hits=-36.7 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,NO_DNS_FOR_FROM, QUOTED_EMAIL_TEXT,REFERENCES,REPLY_WITH_QUOTES, USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/177 X-Sequence-Number: 1118 On Tue, 2003-02-11 at 20:10, Tatsuo Ishii wrote: > Sigh. People always complain "pgbench does not reliably producing > repeatable numbers" or something then say "that's because pgbench's > transaction has too much contention on the branches table". So I added > -N option to pgbench which makes pgbench not to do any UPDATE to > the branches table. But still people continue to complian... What exactly does the -N option do? I see no mention of it in the README.pgbench, which might be part of reason people "continue to complain".