9.0 VACUUM FULL vs. ALTER TABLE?

From: Noah Misch <noah(at)leadboat(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 9.0 VACUUM FULL vs. ALTER TABLE?
Date: 2010-03-06 04:02:26
Message-ID: 20100306040226.GA4509@tornado.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message venkatrao.b 2010-03-06 10:11:40 How to find details of arguments in all functions in postgre - One solution
Previous Message Craig Ringer 2010-03-06 01:37:09 Re: Optimizations