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 C456ED1B527 for ; Tue, 9 Sep 2003 12:45:25 +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 92747-06 for ; Tue, 9 Sep 2003 09:44:58 -0300 (ADT) Received: from mta8.adelphia.net (mta8.adelphia.net [68.168.78.196]) by svr1.postgresql.org (Postfix) with ESMTP id 6C9AFD1B521 for ; Tue, 9 Sep 2003 09:44:39 -0300 (ADT) Received: from potentialtech.com ([24.53.179.151]) by mta8.adelphia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030909124439.OGFU14490.mta8.adelphia.net@potentialtech.com>; Tue, 9 Sep 2003 08:44:39 -0400 Message-ID: <3F5DCB35.3090809@potentialtech.com> Date: Tue, 09 Sep 2003 08:44:37 -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: Andrew Sullivan Cc: pgsql-performance@postgresql.org Subject: Re: increase performancr with "noatime"? References: <200309091612.48937.jerome@gmanmi.tv> <20030909123757.GA18087@libertyrms.info> In-Reply-To: <20030909123757.GA18087@libertyrms.info> 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: 200309/146 X-Sequence-Number: 3512 Andrew Sullivan wrote: > 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. http://www.potentialtech.com/wmoran/postgresql.php#results You can see, from my _limited_ testing, that it doesn't seem to help enough to be worth worrying about. In this test, it actually seems to hurt performance. Read the whole page, though. These tests are heavy on the writing, it's quite possible that it could improve things if your database is a heavy read scenerio. -- Bill Moran Potential Technologies http://www.potentialtech.com