X-Original-To: pgsql-advocacy@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BAEBD475A45; Thu, 13 Feb 2003 01:29:47 -0500 (EST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by postgresql.org (Postfix) with ESMTP id 7331D475EEB; Thu, 13 Feb 2003 01:17:59 -0500 (EST) Received: from DU150.N224.ResNet.QueensU.CA (DU150.N224.ResNet.QueensU.CA [130.15.224.150]) by bob.samurai.com (Postfix) with ESMTP id 431431DD0; Thu, 13 Feb 2003 01:17:58 -0500 (EST) Subject: Re: [HACKERS] More benchmarking of wal_buffers From: Neil Conway To: Christopher Kings-Lynne Cc: PostgreSQL Hackers , pgsql-performance@postgresql.org, pgsql-advocacy@postgresql.org In-Reply-To: References: Content-Type: text/plain Organization: Message-Id: <1045117072.16760.7.camel@tokyo> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 13 Feb 2003 01:17:52 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/57 X-Sequence-Number: 815 On Thu, 2003-02-13 at 00:16, Christopher Kings-Lynne wrote: > Even if you look at the attached charts and you think that 128 buffers are > better than 8, think again - there's nothing in it. Next time I run that > benchmark it could be the same, lower or higher. And the difference between > the worst and best results is less than 3 TPS - ie. nothing. One could conclude that this a result of the irrelevancy of wal_buffers; another possible conclusion is that the testing tool (pgbench) is not a particularly good database benchmark, as it tends to be very difficult to use it to reproduceable results. Alternatively, it's possible that the limited set of test-cases you've used doesn't happen to include any circumstances in which wal_buffers is useful. We definitely need some better benchmarking tools for PostgreSQL (and no, OSDB does not cut it, IMHO). I've been thinking of taking a look at improving this, but I can't promise I'll get the time or inclination to actually do anything about it :-) Cheers, Neil -- Neil Conway || PGP Key ID: DB3C29FC