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
mhh(at)nortelnetworks(dot)com
ESN 451-9008 (302)454-9008
In response to
Responses
pgsql-hackers by date
| Next: | From: Tom Lane | Date: 2000-08-03 19:33:37 |
| Subject: Re: ALTER TABLE |
| Previous: | From: Tom Lane | Date: 2000-08-03 17:48:57 |
| Subject: Toasting more system-table columns |