Re: Keeping creation time of objects - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Keeping creation time of objects
Date
Msg-id 22967.1220988979@sss.pgh.pa.us
Whole thread Raw
In response to Keeping creation time of objects  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Responses Re: Keeping creation time of objects  (daveg <daveg@sonic.net>)
Re: Keeping creation time of objects  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Re: Keeping creation time of objects  ("Robert Haas" <robertmhaas@gmail.com>)
List pgsql-hackers
Devrim GÜNDÜZ <devrim@gunduz.org> writes:
> 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?

There isn't sufficient support for such a "feature".  In any case, why
would creation time (as opposed to any other time, eg last schema
modification, last data modification, yadda yadda) be especially
significant?  Would you expect it to be preserved over dump/restore?
How about every other object type in the system?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: [PATCH] Cleanup of GUC units code
Next
From: daveg
Date:
Subject: Re: Keeping creation time of objects