Re: CLUSTER and indisclustered - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: CLUSTER and indisclustered
Date
Msg-id GNELIHDDFBOCMGBFGEFOIEJLCDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: CLUSTER and indisclustered  (Alvaro Herrera <alvherre@atentus.com>)
Responses Re: CLUSTER and indisclustered  (Alvaro Herrera <alvherre@atentus.com>)
List pgsql-hackers
> > > Or maybe just do an analyze of the table automatically after the
> > > CLUSTERing.
> >
> > Hmmm... I don't really see the problem with adding a note in the docs
> > suggesting that users following a CLUSTER with an ANALYZE (...).
>
> ANALYZE is an inexpensive operation (compared to CLUSTER, anyway), so it
> can't hurt to have it done automatically.

Well we have previously had discussions on the topic of adding analyze to
the end of dumps, etc. and the result has always been in favour of keeping
the command set orthogonal and not doing an automatic analyze...

Chris



pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: Why is MySQL more chosen over PostgreSQL?
Next
From: Alvaro Herrera
Date:
Subject: Re: CLUSTER and indisclustered