Re: Proposal: Store "timestamptz" of database creation on "pg_database"

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Дата
Msg-id 20121227013029.GO12354@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Proposal: Store "timestamptz" of database creation on "pg_database"  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Список pgsql-hackers
* Josh Berkus (josh@agliodbs.com) wrote:
> On 12/26/12 4:48 PM, Fabrízio de Royes Mello wrote:
> >This proposal is about add a column "datcreated" on "pg_database" to store
> >the "timestamp" of the database creation.
>
> I agree that it would be useful.  However, if we're going to get
> into created dates, we should at least consider adding them to the
> other catalogs, particularly pg_class.

I was thinking more-or-less the same thing.  Along those lines, however,
perhaps we should put them into a separate catalog to avoid the
increased size of pg_class and friends..?  Also, we'd probably have 2 of
those, one for global and one for per-database objects, ala pg_depend
and pg_shdepend, and then a view that brings it all together, resolves
the OIDs to names, etc.
Thanks,
    Stephen

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Следующее
От: Tom Lane
Дата:
Сообщение: Re: buffer assertion tripping under repeat pgbench load