knowing last modification / last access times of tables..

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: knowing last modification / last access times of tables..
Date: 2003-04-30 04:04:32
Message-ID: 200304300934.32897.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Justin Long 2003-04-30 13:33:03 Impact of loss of unique SERIAL?
Previous Message Mike Castle 2003-04-29 23:48:15 Re: vacuuming and freed disk space