Re: CLUSTER and indisclustered

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: CLUSTER and indisclustered
Дата
Msg-id GNELIHDDFBOCMGBFGEFOIEJLCDAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: CLUSTER and indisclustered  (Alvaro Herrera <alvherre@atentus.com>)
Ответы Re: CLUSTER and indisclustered
Список 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 по дате отправления:

Предыдущее
От: Don Baccus
Дата:
Сообщение: Re: Why is MySQL more chosen over PostgreSQL?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: CLUSTER and indisclustered