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: 3989BC09.C30A4B9C@americasm01.nt.com (view raw or flat)
Thread:
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
mhh(at)nortelnetworks(dot)com
ESN 451-9008 (302)454-9008

In response to

Responses

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-2014 The PostgreSQL Global Development Group