Heikki Linnakangas <[EMAIL PROTECTED]> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers