Re: Toasting more system-table columns

Поиск
Список
Период
Сортировка
От Mark Hollomon
Тема Re: Toasting more system-table columns
Дата
Msg-id 3989BC09.C30A4B9C@americasm01.nt.com
обсуждение исходный текст
Ответ на Toasting more system-table columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Toasting more system-table columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Mike Mascari
Дата:
Сообщение: Re: comparing rows
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Toasting more system-table columns