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 switching from 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 a while 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
