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

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> No, I was thinking of something along the lines of:
> INFO:  clustering "public.my_c"
> INFO:  complete, was 33%, now 100% clustered
> The only such measure that we have is the correlation, which isn't very 
> good anyway, so I'm not sure if that's worthwhile.

It'd be possible to count the number of order reversals during the
indexscan, ie the number of tuples with CTID lower than the previous
one's.  But I'm not sure how useful that number really is.  Also it's
not clear how to preserve such functionality if cluster is
re-implemented with a sort.
        regards, tom lane