Quote:
Originally Posted by Jehaim
I thought cluster also did a vacuum?
If you are going to CLUSTER then the VACUUM is pretty much redundant. The ANALYZE is still useful but should be done after CLUSTER since its physical-order-correlation stats will be quite wrong if done beforehand. In other words there is only one sane way to do this and it is:
CLUSTER;
ANALYZE
You could possibly make a case for
CLUSTER;
VACUUM;
ANALYZE
The VACUUM won't do anything useful in terms of reclaiming space (there
being none to reclaim just after a CLUSTER) but it would ensure that all
rows in the table are marked as committed-good, rather than leaving that
work to be done by the first transaction that happens to hit each row.
================================================== =======
Copy paste from PT3 forum.