X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 09936D9836 for ; Mon, 26 Sep 2005 22:31:32 -0300 (ADT) 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 61920-01 for ; Tue, 27 Sep 2005 01:31:25 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 462EED9832 for ; Mon, 26 Sep 2005 22:31:28 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j8R1VPDj062811 for ; Tue, 27 Sep 2005 01:31:25 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j8R1SnCT062162 for pgsql-admin@postgresql.org; Tue, 27 Sep 2005 01:28:49 GMT (envelope-from news) From: Gaetano Mendola X-Newsgroups: pgsql.admin Subject: Re: Disk Access Question Date: Tue, 27 Sep 2005 03:28:53 +0200 Organization: Hub.Org Networking Services Lines: 33 Message-ID: <4338A055.3030807@bigfoot.com> References: <1d219a6f0509201055ea11c59@mail.gmail.com> <200509210748.32218.xzilla@users.sourceforge.net> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Robert Treat User-Agent: Thunderbird 1.4 (Windows/20050908) In-Reply-To: <200509210748.32218.xzilla@users.sourceforge.net> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.579 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.241] X-Spam-Level: X-Archive-Number: 200509/292 X-Sequence-Number: 19029 Robert Treat wrote: > On Tuesday 20 September 2005 13:55, Chris Hoover wrote: >> I have a question on disk access. >> >> How often is PostgreSQL accessing/touching the files that are on the hard >> drive? >> >> What I'm trying to ask is, is PostgreSQL constantly updating access >> timestamps or something like that on the database files even if they are >> not being queried? This questions comes from an Oracle background where >> Oracle was updating the individual files every 3 seconds if I am >> remembering correctly. >> >> I am trying to figure out besides the queries, what sort of accessing is >> PostgreSQL doing to my drives so we can try and resolve some i/o issues. >> > > AFAIK unless your actually doing something,it wont access your data files at > all. Note that something is pretty wide here, insert/update/vacuum/analyze > and even select will cause file access but otherwise it wont. You can mount your partition ( on Linux ) specifing the "noatime" option this will avoid your inode access time to be updated when files are only read. Postgres do not use this information so you are safe. Regards Gaetano Mendola