Re: pgsql-server/src/backend/commands cluster.c

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgsql-server/src/backend/commands cluster.c
Дата
Msg-id 25772.1036377763@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pgsql-server/src/backend/commands cluster.c  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-committers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> If the pg_statistic entries were already good, then you shouldn't need
>> an ANALYZE, no.

> The CLUSTER manual page recommends a analyze to update the clustered
> nature of the table.  Is that still needed?

Oh, you're right, I was not thinking about the order-correlation
statistic.  Yes, ANALYZE is still needed if you want to update that
stat, which you probably do.  The swap hack just ensured that relpages
amd reltuples would be correct after a CLUSTER.

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pgsql-server/src/backend/commands cluster.c
Следующее
От: barry@postgresql.org (Barry Lind)
Дата:
Сообщение: pgsql-server/src/interfaces/jdbc/org/postgresq ...