Re: 9.0 VACUUM FULL vs. ALTER TABLE?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 9.0 VACUUM FULL vs. ALTER TABLE?
Date: 2010-03-06 15:27:30
Message-ID: 29527.1267889250@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Noah Misch <noah(at)leadboat(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-03-06 16:05:33 Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)?
Previous Message Adrian von Bidder 2010-03-06 13:55:28 Filesysstems