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 B6295D7D72 for ; Tue, 20 Sep 2005 14:55:49 -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 14312-04 for ; Tue, 20 Sep 2005 17:55:44 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.205]) by svr1.postgresql.org (Postfix) with ESMTP id D5E8AD70A7 for ; Tue, 20 Sep 2005 14:55:43 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id z31so7169nzd for ; Tue, 20 Sep 2005 10:55:44 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type; b=sZ1ORWWw7Qrzxun8lgnik74ygQgsB3MWU9PxcyLN2UQY167UtXq6G2pYg+25l/2KGZ9MOHDMJUNdfrkAo4Kc1gDUAI+SA352NH2bIAe1jTY0UTIslTH8lh0tXC6oZi/N/0uKbAbgSwvjYCToXI1DKI/+0u3m9Fbn0gJgGzd1OdQ= Received: by 10.37.20.63 with SMTP id x63mr4172943nzi; Tue, 20 Sep 2005 10:55:44 -0700 (PDT) Received: by 10.36.24.2 with HTTP; Tue, 20 Sep 2005 10:55:43 -0700 (PDT) Message-ID: <1d219a6f0509201055ea11c59@mail.gmail.com> Date: Tue, 20 Sep 2005 13:55:43 -0400 From: Chris Hoover Reply-To: revoohc@gmail.com To: pgsql-admin@postgresql.org Subject: Disk Access Question Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_38437_3192879.1127238943849" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.101 required=5 tests=[AWL=-0.062, HTML_00_10=0.138, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/206 X-Sequence-Number: 18943 ------=_Part_38437_3192879.1127238943849 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I have a question on disk access. How often is PostgreSQL accessing/touching the files that are on the hard= =20 drive? What I'm trying to ask is, is PostgreSQL constantly updating access=20 timestamps or something like that on the database files even if they are no= t=20 being queried? This questions comes from an Oracle background where Oracle= =20 was updating the individual files every 3 seconds if I am remembering=20 correctly. I am trying to figure out besides the queries, what sort of accessing is=20 PostgreSQL doing to my drives so we can try and resolve some i/o issues. Thanks, Chris ------=_Part_38437_3192879.1127238943849 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I have a question on disk access.

How often is PostgreSQL accessing/touching the files that are on the hard d= rive?

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.

Thanks,

Chris
------=_Part_38437_3192879.1127238943849--