News for hackers. Stuff that matters.
Re:Underrated Features of PostgreSQL by jeffdavis on Thursday November 03, 2011 @12:48AM (#3190341)
As of 9.0, the old version of VACUUM FULL has been replaced with a new implementation closely resembling CLUSTER (except without anything to do with an index, of course).

So, if you need to reclaim unused space in a table (usually only useful after a large delete or update), VACUUM FULL is a reasonable way to do so.

But, if you happen to have a useful index order, you might as well use CLUSTER so you get that benefit at the same time.

There are no comments on this comment yet.