Disadvantage to CLUSTER?

Поиск
Список
Период
Сортировка
От Robert James
Тема Disadvantage to CLUSTER?
Дата
Msg-id CAGYyBghWPxDt4+0A4xv5ox+YErWbkZu-jL=txggo8gy46dSw8A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Disadvantage to CLUSTER?  (Merlin Moncure <mmoncure@gmail.com>)
Re: Disadvantage to CLUSTER?  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-general
Besides the one time spent CLUSTERing, do I loose anything by doing it
for every table?  Does a CLUSTER slow anything down?

It would seem to me that a) a CLUSTER should never have worse
performance than a random order b) may have better performance and c)
has the benefits of a VACUUM and REINDEX.  So, I may as well cluster
every table, if only by the primary key.

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

Предыдущее
От: Robert James
Дата:
Сообщение: Is there a benefit to CLUSTER when retrieving individual records?
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Disadvantage to CLUSTER?