Re: Keeping creation time of objects

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