Re: Problem with TOAST tables when removing TOASTable column

Поиск
Список
Период
Сортировка
От Wojciech Strzałka
Тема Re: Problem with TOAST tables when removing TOASTable column
Дата
Msg-id 323199382.20080514172105@gmail.com
обсуждение исходный текст
Ответ на Re: Problem with TOAST tables when removing TOASTable column  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Problem with TOAST tables when removing TOASTable column  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
> 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.

I agree DROP COLUMN should be cheap and I don't really expect it to happend immediately,
but shouldn't VACUUM FULL clean it up?

                                   Wojtek Strzalka

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

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