Postgres Pro
Downloads
Home   >   mailing lists

knowing last modification / last access times of tables.. - Mailing list pgsql-admin

From Rajesh Kumar Mallah
Subject knowing last modification / last access times of tables..
Date
Msg-id 200304300934.32897.mallah@trade-india.com
Whole thread Raw
Responses Impact of loss of unique SERIAL?  ("Justin Long" <justinlong@strategicnetwork.org>)
List pgsql-admin
Tree view 

Hi ,

we need to get rid of lots of old tables which
we suspect are not in use.

Is there any way to know when a table was last read
or modifed ?


does seeing the access info of the datafiles corresponding to these
tables help ?


Regds
mallah.


--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

pgsql-admin by date:

Previous
From: dalgoda@ix.netcom.com (Mike Castle)
Date:
Subject: Re: vacuuming and freed disk space
Next
From: "Justin Long"
Date:
Subject: Impact of loss of unique SERIAL?