Re: [GENERAL] How much clustered?

2006-02-26 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: 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: It's not an array, because the two components are not of

Re: [GENERAL] How much clustered?

2006-02-26 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: 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: It's not an array, because the two

Re: [GENERAL] How much clustered?

2006-02-24 Thread Bruce Momjian
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

[GENERAL] How much clustered?

2006-02-16 Thread Carlos Henrique Reimer
Hi,I would like to know how much clustered is a table related to some index How can I discover?Reimer Yahoo! doce lar. Faça do Yahoo! sua homepage.

Re: [GENERAL] How much clustered?

2006-02-16 Thread Tom Lane
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