Re: loading data, creating indexes, clustering, vacuum...

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.