On Thursday 07 December 2006 08:38, "Angva" <angvaw@xxxxxxxxx> wrote: > three commands. For instance I have a hunch that creating the indexes > first (as I do now) could slow down the clustering - perhaps the row > locations in the indexes all have to be updated as the cluster command > shifts their locations? And perhaps vacuuming should be done before > clustering so that dead tuples aren't "in the way"? clustering also removes the dead tuples. I would just: - create one index, the one to be clustered - cluster the table - create the remaining indexes -- Eat right. Exercise regularly. Die anyway.
