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.
[ Parent
| on HN ]
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.