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  (Wojciech Strzałka <wstrzalka@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "nicoanto"
Дата:
Сообщение: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows
Следующее
От: Wojciech Strzałka
Дата:
Сообщение: Re: Problem with TOAST tables when removing TOASTable column