News for hackers. Stuff that matters.
Re:Underrated Features of PostgreSQL by einhverfr on Wednesday November 02, 2011 @11:09PM (#3190034)
Clustering is also faster than VACUUM FULL and can be used as a replacement where that is needed.
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.