Keeping creation time of objects

Поиск
Список
Период
Сортировка
От Devrim GÜNDÜZ
Тема Keeping creation time of objects
Дата
Msg-id 1220988000.2711.185.camel@laptop.gunduz.org
обсуждение исходный текст
Ответы Re: Keeping creation time of objects
Re: Keeping creation time of objects
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Patch: plan invalidation vs stored procedures
Следующее
От: "Robert Haas"
Дата:
Сообщение: Re: [PATCH] Cleanup of GUC units code