Re: [HACKERS] ALTER TABLE DROP COLUMN

[Bruce Momjian]

> On Mon, 9 Oct 2000, Tom Lane wrote:
> 
> > The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > >> What happens if you crash partway through?
> > 
> > > what happens if you crash partway through a vacuum?
> > 
> > Nothing.  Vacuum is crash-safe.  ALTER TABLE should be too.
> 
> Sorry, that's what I meant ... why should marking a column as 'deleted'
> and running a 'vacuum' to clean up the physical table be any less
> crash-safe?  

It is not.  The only downside is 2x disk space to make new versions of
the tuple.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [EMAIL PROTECTED]               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026