Skip site navigation (1) Skip section navigation (2)

Re: Toasting more system-table columns

From: "Mark Hollomon" <mhh(at)nortelnetworks(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Toasting more system-table columns
Date: 2000-08-03 18:38:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Tom Lane wrote:
> Offhand it would seem to be a good idea to create toast tables for
> pg_attrdef, pg_description, pg_proc, pg_relcheck, possibly pg_statistic.
> Certainly a toast table for pg_proc is a must so that we can deal with
> large procedure bodies.  Toasting pg_attrdef would allow very large
> column default expressions (dubious value), pg_description for long
> comments (probably should have this), pg_relcheck for long constraint
> expressions (probably want this), pg_statistic to cope with long
> min/max/common values (not sure about this).

I would think pg_statistic would be a 'must'.


Mark Hollomon
ESN 451-9008 (302)454-9008

In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2000-08-03 19:33:37
Subject: Re: ALTER TABLE
Previous:From: Tom LaneDate: 2000-08-03 17:48:57
Subject: Toasting more system-table columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group