Hacker News new | past | comments | ask | show | jobs | submit login

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.

Clustering is also faster than VACUUM FULL and can be used as a replacement where that is needed.

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.

Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | Legal | Apply to YC | Contact