Re: AW: ALTER TABLE DROP COLUMN

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: AW: ALTER TABLE DROP COLUMN
Дата
Msg-id 39E713C4.6CC93F42@tm.ee
обсуждение исходный текст
Ответ на AW: ALTER TABLE DROP COLUMN  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Список pgsql-hackers
Tom Lane wrote:
> 
> Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
> > My conclusion would be that we need both:
> > 1. a fast system table only solution with physical/logical column id
> > 2. a tool that does the cleanup (e.g. vacuum)
> 
> But the peak space usage during cleanup must still be 2X.

Perhaps he means some kind of off-line cleanup tool, that has only the 
requirement of being able to continue from where it left off (or
crashed) ?

It could be useful in some cases (like removing a column on saturday
from a 
terabyte-sized file that is used only on weekdays :)

----------
Hannu


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

Предыдущее
От: "Clark, Joel"
Дата:
Сообщение: RE: [INTERFACES] Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL
Следующее
От: Dan Moschuk
Дата:
Сообщение: -d 2 frustration