Horton

Re: AW: ALTER TABLE DROP COLUMN

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
Cc: The Hermit Hacker <scrappy@hub.org>, Bruce Momjian <pgman@candle.pha.pa.us>, Hiroshi Inoue <Inoue@tpf.co.jp>, PostgreSQL Development <pgsql-hackers@postgreSQL.org>
Date: 2000-10-12T14:38:37Z
Lists: pgsql-hackers 
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.

			regards, tom lane