Re: Unused system table columns

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.

In response to

Responses

Browse pgsql-hackers by date

  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