Keeping creation time of objects

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: PostgreSQL Hackers ML <pgsql-hackers(at)postgresql(dot)org>
Subject: Keeping creation time of objects
Date: 2008-09-09 19:20:00
Message-ID: 1220988000.2711.185.camel@laptop.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2008-09-09 19:33:37 Re: [PATCH] Cleanup of GUC units code
Previous Message Tom Lane 2008-09-09 19:05:12 Re: Patch: plan invalidation vs stored procedures