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 62027D1B50E for ; Tue, 9 Sep 2003 16:09:39 +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 36861-01 for ; Tue, 9 Sep 2003 13:09:07 -0300 (ADT) Received: from lorax.kciLink.com (lorax.kciLink.com [206.112.95.1]) by svr1.postgresql.org (Postfix) with ESMTP id 7AAB7D1B4EA for ; Tue, 9 Sep 2003 13:09:07 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by lorax.kciLink.com (Postfix) with ESMTP id 249993EC1 for ; Tue, 9 Sep 2003 12:09:07 -0400 (EDT) Received: from lorax.kciLink.com ([127.0.0.1]) by localhost (lorax.kciLink.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 87313-03-3 for ; Tue, 9 Sep 2003 12:08:56 -0400 (EDT) Received: from lorax.kciLink.com (localhost [127.0.0.1]) by lorax.kciLink.com (Postfix) with ESMTP id 959CB3E42 for ; Tue, 9 Sep 2003 12:08:56 -0400 (EDT) Received: (from news@localhost) by lorax.kciLink.com (8.12.8p1/8.12.8/Submit) id h89G8tHi010978 for pgsql-performance@postgresql.org; Tue, 9 Sep 2003 12:08:55 -0400 (EDT) To: pgsql-performance@postgresql.org Path: not-for-mail From: Vivek Khera Newsgroups: ml.postgres.performance Subject: Re: increase performancr with "noatime"? Date: Tue, 09 Sep 2003 12:08:55 -0400 Organization: Khera Communications, Inc., Rockville, MD Lines: 23 Message-ID: References: <200309091612.48937.jerome@gmanmi.tv> <20030909123757.GA18087@libertyrms.info> NNTP-Posting-Host: yertle.kcilink.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: lorax.kciLink.com 1063123735 8185 216.194.193.105 (9 Sep 2003 16:08:55 GMT) X-Complaints-To: daemon@kciLink.com NNTP-Posting-Date: Tue, 9 Sep 2003 16:08:55 +0000 (UTC) User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Portable Code, berkeley-unix) Cancel-Lock: sha1:l2uQJw5Yd88dGWTwLKoJp6527ao= X-Virus-Scanned: by amavisd-new at kciLink.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/155 X-Sequence-Number: 3521 >>>>> "AS" == Andrew Sullivan writes: AS> 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"? AS> No; in fact, that's been suggested by many people. I don't know AS> whether anyone's done any tests to prove that it helps. I honestly can't expect it to be much of an improvement since the number of files involved compared with the size of the files is minimal. However, if you're opening/closing the files often it might cause you problems. I think in the normal case where it does matter you have pooled connections so the open/close happens rarely. Of course, if I had a good synthetic workload to pound on my DB, I'd run a test... Sean? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/