Re: TODO item: adding VERBOSE option to CLUSTER [with patch] - Mailing list pgsql-hackers

From Tom Lane
Subject Re: TODO item: adding VERBOSE option to CLUSTER [with patch]
Date
Msg-id 26362.1223928374@sss.pgh.pa.us
Whole thread Raw
In response to Re: TODO item: adding VERBOSE option to CLUSTER [with patch]  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: TODO item: adding VERBOSE option to CLUSTER [with patch]
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: There's some sort of race condition with the new FSM stuff
Next
From: Gregory Stark
Date:
Subject: Re: TODO item: adding VERBOSE option to CLUSTER [with patch]