Postgres Pro
Downloads
Home   >   mailing lists

Keeping creation time of objects - Mailing list pgsql-hackers

From Devrim GÜNDÜZ
Subject Keeping creation time of objects
Date
Msg-id 1220988000.2711.185.camel@laptop.gunduz.org
Whole thread Raw
Responses Re: Keeping creation time of objects  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Keeping creation time of objects  (David Fetter <david@fetter.org>)
List pgsql-hackers
Tree view 
Hi,

AFAICS, PostgreSQL is not keeping info about when a table, database,
sequence, etc was created. We cannot get that info even from OS, since
CLUSTER or VACUUM FULL may change the metadata of corresponding
relfilenode.

Does anyone think that adding a timestamp column to pg_class would bring
an overhead? For me, it looks a bit easy to add that value while calling
CREATE XXX, but does anyone see a corner case?

Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr                  http://www.gunduz.org

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch: plan invalidation vs stored procedures
Next
From: "Robert Haas"
Date:
Subject: Re: [PATCH] Cleanup of GUC units code