Scott Carey wrote:
> CLUSTER also does *nothing at all* to a table unless you have chosen an index to CLUSTER on. Its not as simple as
switchingfrom VACUUM or VACUUM FULL to CLUSTER.
>
> Does CLUSTER also REINDEX? I seem to recall reducing the size of my indexes by REINDEXing after a CLUSTER, but it was
awhile ago and I could have been mistaken.
AFAIK CLUSTER builds a new copy of the table, and new indexes for it,
then swaps them into the old table and index's place.
--
Craig Ringer