Re: Disk Access Question - Mailing list pgsql-admin

FromChris Hoover
SubjectRe: Disk Access Question
Date
Msg-id[email protected]
Whole thread Raw
In response toDisk Access Question  (Chris Hoover <[email protected]>)
Listpgsql-admin
Sorry, for got to mention pg 7.3.4.

On 9/20/05, Chris Hoover <[email protected]> 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