Skip site navigation (1) Skip section navigation (2)

Disk Access Question

From: Chris Hoover <revoohc(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Disk Access Question
Date: 2005-09-20 17:55:43
Message-ID: 1d219a6f0509201055ea11c59@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Chris HooverDate: 2005-09-20 18:02:33
Subject: Re: Disk Access Question
Previous:From: Craig ServinDate: 2005-09-20 17:50:26
Subject: Re: Replication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group