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

Thank you very much, Alan and Martijn, for the advice!

Mark

Martijn van Oosterhout wrote:
> On Thu, Dec 07, 2006 at 02:52:11PM -0800, Alan Hodgson wrote:
> > On Thursday 07 December 2006 08:38, "Angva" <angvaw(at)gmail(dot)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
>
> And then run ANALYSE. No need to vacuum because the cluster did that
> already.
>
> Have a nice day,
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> > From each according to his ability. To each according to his ability to litigate.
>
> --fXStkuK2IQBfcDe+
> Content-Type: application/pgp-signature
> Content-Disposition: inline;
> filename="signature.asc"
> Content-Description: Digital signature
> X-Google-AttachSize: 190