Re: Which Order Vacuum Full Analyze Cluster Reindex?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Which Order Vacuum Full Analyze Cluster Reindex?
Дата
Msg-id 15050.1093662856@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Which Order Vacuum Full Analyze Cluster Reindex?  ("borajetta" <borajetta@hotmail.com>)
Ответы Re: Which Order Vacuum Full Analyze Cluster Reindex?
Список pgsql-general
"borajetta" <borajetta@hotmail.com> writes:
> I am trying to firgure out what the best order is?

> Vacuum Full table;
> Cluster table;
> Analyze table;

If you are going to CLUSTER then you can forget the VACUUM part
entirely.  Just do CLUSTER and then ANALYZE.

            regards, tom lane

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