From: Kevin Neufeld <kneufeld@refractions.net>
To: pgsql-admin@postgresql.org
Subject: table creation/modification datestamp
Date: Mon, 26 May 2008 11:18:37 -0700
Message-ID: <483AFEFD.2000504@refractions.net> (raw)
As a DBA, it would be extremely useful to know when tables have been
created or modified. PostgreSQL doesn't keep track of this, does it?
(Table modification, in my mind, includes INSERTs, DELETEs, UPDATEs, and
changes performed via ALTER TABLE. It does not include physical changes
that may occur on the table due to VAACUMing or CLUSTERing.)
Obviously, I can't use the relfilenode attribute in pg_class to check
for table modification and look up the file's timestamp, since the OS
updates the timestamp whenever physical changes occur. Further, I don't
think linux even tracks a file's creation timestamp.
The stats collector already tracks when a table was last ANALYZED, it
would be nice to expand this functionality to include table
creation/modification times. (Ideally, table timestamp record keeping
should be persistent over db dumps and restores.)
Cheers,
Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kneufeld@refractions.net
Subject: Re: table creation/modification datestamp
In-Reply-To: <483AFEFD.2000504@refractions.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox