Re: CLUSTER all tables at once?

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: CLUSTER all tables at once?
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961E48@m0114.s-mxs.net
обсуждение исходный текст
Ответ на CLUSTER all tables at once?  (Alvaro Herrera <alvherre@atentus.com>)
Ответы Re: CLUSTER all tables at once?
Список pgsql-hackers
> Added to TODO:
>
>     o Cluster all tables at once using pg_index.indisclustered or primary key
>
> > > And what happens with those tables that do not have any such index?
> >
> > Nothing, would be my vote.  You'd just re-CLUSTER all tables that have
> > been clustered before, the same way they were last clustered.

I second Tom's opinion. If the table was not clustered before leave it as is.

Thus the TODO should imho (if at all :-) read:o Cluster all tables at once that have a pg_index.indisclustered

Andreas


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: Domains and Indexes
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: Open 7.3 items