X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4647B8B9BA0 for ; Tue, 22 Feb 2005 23:44:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57397-01 for ; Tue, 22 Feb 2005 23:44:51 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 925D38B9B3B for ; Tue, 22 Feb 2005 23:44:52 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j1MNip7j013402; Tue, 22 Feb 2005 18:44:51 -0500 (EST) To: cjwhite@cisco.com Cc: pgsql-admin@postgresql.org Subject: Re: 7.4.5 file write issue In-reply-to: <200502222246.j1MMkDYO007021@sj-core-4.cisco.com> References: <200502222246.j1MMkDYO007021@sj-core-4.cisco.com> Comments: In-reply-to "Chris White (cjwhite)" message dated "Tue, 22 Feb 2005 14:46:12 -0800" Date: Tue, 22 Feb 2005 18:44:51 -0500 Message-ID: <13401.1109115891@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/241 X-Sequence-Number: 16409 "Chris White (cjwhite)" writes: > We are noticing on our 7.4.5 system the following files are being written > approximately every 5 minutes > /tmp/.s.PGSQL.5432 > /tmp/.s.PGSQL.5432.lock > Anybody know why they are being written? So they don't get eaten by overenthusiastic /tmp cleaner scripts. > The reason I ask is because we are > running on a system that uses a laptop disk drive and requires at least 10 > minutes idle time to spindown so it can recalibrate. This did not happen > when we were running 7.4.2, so does anybody have any idea what may have > changed between 7.4.2 and 7.4.5 to cause this to happen. In 7.4 it's done every checkpoint. Perhaps you changed your checkpoint settings? In 8.0 it looks like the interval is hardwired to 10 minutes; you'd have to hack postmaster.c if you don't like it. regards, tom lane