Re: AW: ALTER TABLE DROP COLUMN - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: AW: ALTER TABLE DROP COLUMN
Date
Msg-id 39E713C4.6CC93F42@tm.ee
Whole thread Raw
In response to AW: ALTER TABLE DROP COLUMN  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List 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 by date:

Previous
From: "Clark, Joel"
Date:
Subject: RE: [INTERFACES] Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL
Next
From: Dan Moschuk
Date:
Subject: -d 2 frustration