X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id 8BB3ACCD6F for ; Fri, 18 Jul 2003 16:28:44 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 40526-08 for ; Fri, 18 Jul 2003 16:29:06 +0000 (GMT) Received: from mail2.mediadesign.nl (md2.mediadesign.nl [212.19.205.67]) by svr1.postgresql.org (Postfix) with SMTP id 49917CCD6C for ; Fri, 18 Jul 2003 13:28:32 -0300 (ADT) Received: (qmail 795 invoked by uid 666); 18 Jul 2003 16:28:55 -0000 Date: Fri, 18 Jul 2003 18:28:55 +0200 From: Vincent van Leeuwen To: pgsql-performance@postgresql.org Subject: Re: Sanity check requested Message-ID: <20030718162854.GW21071@md2.mediadesign.nl> Mail-Followup-To: pgsql-performance@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.28i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/299 X-Sequence-Number: 2592 On 2003-07-18 18:20:55 +0200, Oliver Scheit wrote: > > Be sure to mount noatime > > I did "chattr -R +A /var/lib/pgsql/data" > that should do the trick as well or am I wrong? > According to the man page it gives the same effect. There are a few things you should consider though: - new files won't be created with the same options (I think), so you'll have to run this command as a daily cronjob or something to that effect - chattr is probably more filesystem-specific than a noatime mount, although this isn't a problem on ext[23] ofcourse Vincent van Leeuwen Media Design - http://www.mediadesign.nl/