Re: Vacuum Full

On Wed, Apr 01, 2009 at 08:09:31PM -0400, Tom Lane wrote:

> > Nowadays, with many many new users, and no historical context, they do
> > just take it for "a better kind of vacuum" when in fact it is really
> > like reindex to indexes. I'd vote for rebuild [table]; as the new way
> > to spell vacuum full;
>
> Well, no, "rebuild" is a pretty lousy description for it. I'd expect
> "rebuild" to mean something like a no-op rewrite in ALTER TABLE.
>
> It is true that VACUUM FULL's use case has decreased nearly to the
> vanishing point, and the maintenance effort for it is way out of
> proportion to the use case. Maybe we should remove the code and make
> VACUUM FULL do the table-rewrite thing.

What do you mean with "the table-rewrite thing", exactly?

Tino.

--
"What we nourish flourishes." - "Was wir nähren erblüht."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de