Re: Toasting more system-table columns - Mailing list pgsql-hackers

From Mark Hollomon
Subject Re: Toasting more system-table columns
Date
Msg-id 3989BC09.C30A4B9C@americasm01.nt.com
Whole thread Raw
In response to Toasting more system-table columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Toasting more system-table columns
List 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@nortelnetworks.com
ESN 451-9008 (302)454-9008


pgsql-hackers by date:

Previous
From: Mike Mascari
Date:
Subject: Re: comparing rows
Next
From: Tom Lane
Date:
Subject: Re: Toasting more system-table columns