Re: VACUUM FULL for performance - Mailing list pgsql-general

Leonardo Francalanci <m_lists@yahoo.it> writes:
>> I also  recommend reindexing any table that has been VACUUM FULLed.

> Mmmh, from the docs I get that in 9.0 a "vacuum full" rewrites the whole table,
> so I expect the indexes to be re-created anyway... so a reindexing would
> be totally useless.

Any discussion of VACUUM FULL has to recognize that 9.0's implementation
of it is completely different from all prior versions.  It still has
disadvantages, but not the ones that were there before.

            regards, tom lane