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 A363FD1B8B3 for ; Fri, 29 Aug 2003 01:37:37 +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 45899-04 for ; Thu, 28 Aug 2003 22:37:09 -0300 (ADT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by svr1.postgresql.org (Postfix) with ESMTP id 8D7D6D1B8E0 for ; Thu, 28 Aug 2003 22:37:04 -0300 (ADT) Received: from mars (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9/8.12.9) with SMTP id h7T1axLt034462; Fri, 29 Aug 2003 09:36:59 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <06e801c36dce$81a153b0$2800a8c0@mars> From: "Christopher Kings-Lynne" To: "Ron Johnson" , "PgSQL Performance ML" References: <3F4C0DC4.8070105@potentialtech.com> <1062062608.25226.182.camel@haggis> Subject: Re: The results of my PostgreSQL/filesystem performance Date: Fri, 29 Aug 2003 09:40:18 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/454 X-Sequence-Number: 3270 > > 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. He also wonders how bug the default IO is? Chris