On Thursday 07 December 2006 08:38, "Angva" <angvaw@gmail.com> 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.
