Carlos Henrique Reimer <[EMAIL PROTECTED]> writes:
> I would like to know how much clustered is a table related to some
> index.... How can I discover?
You could do
select ctid from mytable order by indexcolumns
and then do whatever sort of calculation strikes your fancy on the
sequence of page numbers. (It's probably fair to ignore the row
numbers, considering an index to be fully clustered if the page
reference sequence is perfect.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
