X-Original-To: pgsql-advocacy@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1D1B6474E4F; Thu, 13 Feb 2003 23:00:57 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 54D0B474E42; Thu, 13 Feb 2003 23:00:56 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2839304; Thu, 13 Feb 2003 20:01:08 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Tatsuo Ishii , tgl@sss.pgh.pa.us Subject: Re: [HACKERS] Changing the default configuration Date: Thu, 13 Feb 2003 20:00:35 -0800 User-Agent: KMail/1.4.3 Cc: justin@postgresql.org, merlin.moncure@rcsonline.com, pgsql-hackers@postgresql.org, pgsql-advocacy@postgresql.org References: <26582.1044984365@sss.pgh.pa.us> <26850.1044985975@sss.pgh.pa.us> <20030212.101000.74752335.t-ishii@sra.co.jp> In-Reply-To: <20030212.101000.74752335.t-ishii@sra.co.jp> MIME-Version: 1.0 Message-Id: <200302132000.35639.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/73 X-Sequence-Number: 831 Tatsuo, > 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... Hey, pg_bench is a good start on a Postgres performance tester, and it's mu= ch,=20 much better than what there was before you came along ... which was nothing= .=20=20 Thank you again for contributing it. pg_bench is, however, only a start on a performance tester, and we'd need = to=20 build it up before we could use it as the basis of a PG tuner. --=20 Josh Berkus Aglio Database Solutions San Francisco