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 8BF4CD1B8B3 for ; Fri, 29 Aug 2003 02:15:47 +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 62430-03 for ; Thu, 28 Aug 2003 23:15:20 -0300 (ADT) Received: from mta3.adelphia.net (mta3.adelphia.net [68.168.78.181]) by svr1.postgresql.org (Postfix) with ESMTP id 72AC3D1B97C for ; Thu, 28 Aug 2003 23:15:16 -0300 (ADT) Received: from potentialtech.com ([24.53.179.151]) by mta3.adelphia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030829021522.YIO6558.mta3.adelphia.net@potentialtech.com>; Thu, 28 Aug 2003 22:15:22 -0400 Message-ID: <3F4EB738.1060203@potentialtech.com> Date: Thu, 28 Aug 2003 22:15:20 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.3) Gecko/20030429 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Christopher Kings-Lynne Cc: Ron Johnson , PgSQL Performance ML Subject: Re: The results of my PostgreSQL/filesystem performance References: <3F4C0DC4.8070105@potentialtech.com> <1062062608.25226.182.camel@haggis> <06e801c36dce$81a153b0$2800a8c0@mars> In-Reply-To: <06e801c36dce$81a153b0$2800a8c0@mars> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/457 X-Sequence-Number: 3273 Christopher Kings-Lynne wrote: >>>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 >> >>I notice that the Linux FSs weren't tested with noatime. Any >>reason? > > My friend, (a FreeBSD committer), was wondering what the results are if you > turn off softupdates (to match Linux default installation) and use noatime. Keep an eye on the page. The test results will be posted shortly after I finish them. Keep in mind, I'm more interested in figuring out what can be done to make Postgres _faster_, so tests along that line are going to have a higher priority than ones that specifically compare "apples to apples" or anything like that. > He also wonders how bug the default IO is? Huh? -- Bill Moran Potential Technologies http://www.potentialtech.com