> On Mon, 9 Oct 2000, Tom Lane wrote:
>
> > The Hermit Hacker <scrappy@hub.org> 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 pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026