2 ms·
Clustered indexes are really useful, too. They drastically speed up certain types of queries, though there is the overhead of having to periodically run CLUSTER
by apinstein 15y ago
Clustered indexes are really useful, too. They drastically speed up certain types of queries, though there is the overhead of having to periodically run CLUSTER.
- einhverfr 15y agoClustering 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.