Re: Problem with TOAST tables when removing TOASTable column

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with TOAST tables when removing TOASTable column
Дата
Msg-id 19781.1210777881@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with TOAST tables when removing TOASTable column  (Wojciech Strzałka <wstrzalka@gmail.com>)
Ответы Re: Problem with TOAST tables when removing TOASTable column
Список pgsql-bugs
Wojciech Strzałka <wstrzalka@gmail.com> writes:
> In my opinion the fact that dropping column doesn't release it's toastable resources is a bug.

To make that happen would require (at least) a full table scan.  I think
most people are more interested in DROP COLUMN being a cheap operation
than in having the space be reclaimed quickly.

For a comparison point: large field values that don't happen to get
toasted don't vanish immediately, either.
        regards, tom lane


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