Tom Lane wrote:
> 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.)
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. +
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
