Horton

Re: [HACKERS] Happy column dropping

Don Baccus <dhogaza@pacifier.com>

View thread
From: Don Baccus <dhogaza@pacifier.com>
To: Hannu Krosing <hannu@tm.ee>, The Hermit Hacker <scrappy@hub.org>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter_e@gmx.net>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2000-01-23T22:03:55Z
Lists: pgsql-hackers 
At 12:04 AM 1/24/00 +0200, Hannu Krosing wrote:

>It could possibly be done by marking the column deleted and doing the 
>compression/renumbering during vacuum , or by locking the table and 
>compressing each page in-place if space is a concern or maybe several 
>other ways. 
>The existence of several ways to do it should not discourage people 
>from actually adding the drop column feature to postgres

It should provide even more encouragement to discuss the proposed
implementation *first*.

IMHO, again.




- Don Baccus, Portland OR <dhogaza@pacifier.com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.