Re: Disk Access Question - Mailing list pgsql-admin

From Chris Hoover
Subject Re: Disk Access Question
Date
Msg-id 1d219a6f05092011021da2b08d@mail.gmail.com
Whole thread Raw
In response to Disk Access Question  (Chris Hoover <revoohc@gmail.com>)
List pgsql-admin
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 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.

Thanks,

Chris

pgsql-admin by date:

Previous
From: Chris Hoover
Date:
Subject: Disk Access Question
Next
From: Robert Ngo
Date:
Subject: postgresql cluster on SAN