Re: Unused system table columns - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Unused system table columns
Date
Msg-id 1026774082.63290.13.camel@jester
Whole thread Raw
In response to Unused system table columns  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Unused system table columns
List 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.




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] CLUSTER not lose indexes
Next
From: Peter Eisentraut
Date:
Subject: Re: getopt_long search in configure