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

From Tom Lane
Subject Re: 9.0 VACUUM FULL vs. ALTER TABLE?
Date
Msg-id 29527.1267889250@sss.pgh.pa.us
Whole thread Raw
In response to 9.0 VACUUM FULL vs. ALTER TABLE?  (Noah Misch <noah@leadboat.com>)
List pgsql-general
Noah Misch <noah@leadboat.com> writes:
> 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,

No.  They're pretty much the same.

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian von Bidder
Date:
Subject: Filesysstems
Next
From: Tom Lane
Date:
Subject: Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)?