Re: How much clustered?

Carlos Henrique Reimer <carlosreimer@yahoo.com.br> 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