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 D8E67D938C for ; Tue, 20 Sep 2005 15:02:40 -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 12209-10 for ; Tue, 20 Sep 2005 18:02:37 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.199]) by svr1.postgresql.org (Postfix) with ESMTP id 132A8D8B36 for ; Tue, 20 Sep 2005 15:02:32 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 34so1197156nzf for ; Tue, 20 Sep 2005 11:02:33 -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:in-reply-to:mime-version:content-type:references; b=pHSFR0zfyZPI237Ahg1MOfDT7kASrPRCbrjcutKl/dqj9bzaiDD1OkibXhVoajvcZa8TDyUzI5eqU38nvNQMJA3R0EvowflIYBKtfR+gxxy/iAOgW0SJpuXzE3e+g/KYYT3m2+9utzGbvEUGyJB1IgNYlcJR09X4IrEV3+FMlxo= Received: by 10.37.12.42 with SMTP id p42mr4153352nzi; Tue, 20 Sep 2005 11:02:33 -0700 (PDT) Received: by 10.36.24.2 with HTTP; Tue, 20 Sep 2005 11:02:33 -0700 (PDT) Message-ID: <1d219a6f05092011021da2b08d@mail.gmail.com> Date: Tue, 20 Sep 2005 14:02:33 -0400 From: Chris Hoover Reply-To: revoohc@gmail.com To: pgsql-admin@postgresql.org Subject: Re: Disk Access Question In-Reply-To: <1d219a6f0509201055ea11c59@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_38486_11603999.1127239353413" References: <1d219a6f0509201055ea11c59@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.061 required=5 tests=[AWL=-0.020, HTML_30_40=0.056, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/207 X-Sequence-Number: 18944 ------=_Part_38486_11603999.1127239353413 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Sorry, for got to mention pg 7.3.4. On 9/20/05, Chris Hoover wrote: >=20 > I have a question on disk access. >=20 > How often is PostgreSQL accessing/touching the files that are on the hard= =20 > drive? >=20 > 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 = not=20 > being queried? This questions comes from an Oracle background where Oracl= e=20 > was updating the individual files every 3 seconds if I am remembering=20 > correctly. >=20 > 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. >=20 > Thanks, >=20 > Chris > ------=_Part_38486_11603999.1127239353413 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Sorry, for got to mention pg 7.3.4.

On 9/20/05, Chris Hoover <revoohc@gmail.com> wrote: 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_38486_11603999.1127239353413--