9.0 VACUUM FULL vs. ALTER TABLE? - Mailing list pgsql-general

From Noah Misch
Subject 9.0 VACUUM FULL vs. ALTER TABLE?
Date
Msg-id 20100306040226.GA4509@tornado.leadboat.com
Whole thread Raw
Responses Re: 9.0 VACUUM FULL vs. ALTER TABLE?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I understand that 9.0 will have a new implementation of VACUUM FULL that follows
a rewrite strategy like CLUSTER or ALTER TABLE.  What differences will remain
between VACUUM FULL and a no-op ALTER TABLE that rewrites?  Will there remain
situations in which to prefer the latter, or will it essentially boil down to
two different spellings of the same request?

CREATE TABLE t (x int);
VACUUM FULL t;
-- versus
ALTER TABLE t ALTER x TYPE int;

Thanks,
nm

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Optimizations
Next
From: venkatrao.b@tcs.com
Date:
Subject: How to find details of arguments in all functions in postgre - One solution