From: | Rod Taylor <rbt(at)zort(dot)ca> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Unused system table columns |
Date: | 2002-07-15 23:01:22 |
Message-ID: | 1026774082.63290.13.camel@jester |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
For all intent and purpose, pg_index.indisprimary can be added to that
list. Can't make a primary key without a pg_constraint entry.
The below are also reported unused by the documentation:
pg_class.relukeys
pg_class.relfkeys
pg_class.relrefs
pg_index.indisclustered
pg_index.indreference
On Mon, 2002-07-15 at 18:53, Peter Eisentraut wrote:
> The following system table columns are currently unused and don't appear
> to be in the line of resurrection.
> pg_language.lancompiler
> pg_operator.oprprec
> pg_operator.oprisleft
> pg_proc.probyte_pct
> pg_proc.properbyte_cpu
> pg_proc.propercall_cpu
> pg_proc.prooutin_ratio
> pg_shadow.usetrace
> pg_type.typprtlen
> pg_type.typreceive
> pg_type.typsend
>
> This adds up to quite some space -- on disk and on the screen. I think we
> should remove them.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2002-07-15 23:04:48 | Re: utils C files |
Previous Message | Bruce Momjian | 2002-07-15 22:58:41 | Re: [PATCHES] CLUSTER not lose indexes |