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 CDE19D1B4FF for ; Tue, 9 Sep 2003 12:38:04 +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 92680-04 for ; Tue, 9 Sep 2003 09:37:57 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id B1526D1B4FE for ; Tue, 9 Sep 2003 09:37:53 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19whkr-0008J9-00 for ; Tue, 09 Sep 2003 08:37:57 -0400 Received: by dba2 (Postfix, from userid 1019) id 6D933C583; Tue, 9 Sep 2003 08:37:57 -0400 (EDT) Date: Tue, 9 Sep 2003 08:37:57 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: increase performancr with "noatime"? Message-ID: <20030909123757.GA18087@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <200309091612.48937.jerome@gmanmi.tv> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200309091612.48937.jerome@gmanmi.tv> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/144 X-Sequence-Number: 3510 On Tue, Sep 09, 2003 at 04:12:48PM +0800, JM wrote: > would it cause problem in postgres DB if /var/lib/psql partition is mounted > with "noatime"? No; in fact, that's been suggested by many people. I don't know whether anyone's done any tests to prove that it helps. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110