TOAST & DROP COLUMN (Was: RE: pgsql-server/ oc/src/sgml/ref/cluster.sgml rc/ ... )

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема TOAST & DROP COLUMN (Was: RE: pgsql-server/ oc/src/sgml/ref/cluster.sgml rc/ ... )
Дата
Msg-id GNELIHDDFBOCMGBFGEFOGEKACDAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: pgsql-server/ oc/src/sgml/ref/cluster.sgml rc/ ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: TOAST & DROP COLUMN (Was: RE: pgsql-server/ oc/src/sgml/ref/cluster.sgml rc/ ... )  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
> I was too tired last night to really think about this.  What I had in
> mind when I wrote the above was to somehow disable the TOAST machinery
> while copying tuples, so that any toasted values in the new heap would
> still reference the old toast table.  That would avoid "unnecessary"
> copying of the toasted datums ... but it looks ugly to do.

Incidentally - will a dropped column definitely have its TOAST data
reclaimed when you do the "update set col=col;" ?

Chris


В списке pgsql-committers по дате отправления:

Предыдущее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: TOAST & DROP COLUMN (Was: RE: pgsql-server/ oc/src/sgml/ref/cluster.sgml rc/ ... )