Re: How much clustered?

Tom Lane wrote:
> Carlos Henrique Reimer <carlosreimer(at)yahoo(dot)com(dot)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.)

Currently we output the ctid as a string:

snprintf(buf, sizeof(buf), "(%u,%u)", blockNumber, offsetNumber);

Perhaps someday we should consider outputting that as an array or a
result set:

test=> select x from (select 1, 2) as x;
x
-------
(1,2)
(1 row)

--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com

+ If your life is a hard drive, Christ can be your backup. +