* Josh Berkus (josh(at)agliodbs(dot)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.
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2012-12-27 03:17:24|
|Subject: Re: buffer assertion tripping under repeat pgbench load|
|Previous:||From: Josh Berkus||Date: 2012-12-27 01:08:13|
|Subject: Re: Proposal: Store "timestamptz" of database creation