Re: TODO item: adding VERBOSE option to CLUSTER [with patch]

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: TODO item: adding VERBOSE option to CLUSTER [with patch]
Дата
Msg-id 26362.1223928374@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: TODO item: adding VERBOSE option to CLUSTER [with patch]  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: TODO item: adding VERBOSE option to CLUSTER [with patch]  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
>> Until we have a better metric for "sortedness", my earlier suggestion to print
>> it was probably a bad idea. If anything, should probably print the same
>> correlation metric that ANALYZE calculates, so that it would at least match
>> what the planner uses for decision-making.

> I agree with that. I like the idea of printing a message though -- we should
> just have it print the correlation for now and when we improve the stats we'll
> print the new metric.

Short of actually running an ANALYZE, I'm not seeing a good way to
derive the same number it derives.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: There's some sort of race condition with the new FSM stuff
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: TODO item: adding VERBOSE option to CLUSTER [with patch]