X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B4A93D1DA61 for ; Thu, 28 Aug 2003 09:19:52 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 86686-08 for ; Thu, 28 Aug 2003 06:19:22 -0300 (ADT) Received: from lakemtao04.cox.net (lakemtao04.cox.net [68.1.17.241]) by svr1.postgresql.org (Postfix) with ESMTP id 98084D1DA4D for ; Thu, 28 Aug 2003 06:19:19 -0300 (ADT) Received: from lhosts ([68.11.66.83]) by lakemtao04.cox.net (InterMail vM.5.01.06.04 201-253-122-130-104-20030726) with ESMTP id <20030828091922.WUTV419.lakemtao04.cox.net@lhosts> for ; Thu, 28 Aug 2003 05:19:22 -0400 Subject: Re: The results of my PostgreSQL/filesystem performance From: Ron Johnson To: PgSQL Performance ML In-Reply-To: <3F4C0DC4.8070105@potentialtech.com> References: <3F4C0DC4.8070105@potentialtech.com> Content-Type: text/plain Message-Id: <1062062361.25751.179.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Thu, 28 Aug 2003 04:19:21 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/402 X-Sequence-Number: 3218 On Tue, 2003-08-26 at 20:47, Bill Moran wrote: > Hey all. > > I said I was going to do it, and I finally did it. > > As with all performance tests/benchmarks, there are probably dozens or > more reasons why these results aren't as accurate or wonderful as they > should be. Take them for what they are and hopefully everyone can > learn a few things from them. > > Intelligent feedback is welcome. > > http://www.potentialtech.com/wmoran/postgresql.php Hi, Woody has pg 7.2.1. Note also that Woody comes with kernel 2.4.18. It would be interesting to see how Debian Sid (kernel 2.4.21 and pg 7.3.3) would perform. Thanks for the results! -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA "Oh, great altar of passive entertainment, bestow upon me thy discordant images at such speed as to render linear thought impossible" Calvin, regarding TV