3 ms·
Clustering is also faster than VACUUM FULL and can be used as a replacement where that is needed.
by einhverfr 15y ago
Clustering is also faster than VACUUM FULL and can be used as a replacement where that is needed.
- jeffdavis 15y agoAs 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.