Search Postgresql Archives

Re: How much clustered?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tom Lane wrote:
> Bruce Momjian <pgman@xxxxxxxxxxxxxxxx> 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 the same data
> type; and it's not a result set, any more than (say) a point or a box
> is.  What it is is a record datatype.
> 
> There might be some usefulness to adding SQL functions to allow
> extraction of the block number and item number fields, though we'd have
> some problems with the lack of a uint4 datatype to represent the block
> number field's type.  The demand for this has been too low to make me
> feel we need to expend that effort...

Agreed, I was just pointing out that someday it might need improvement.

-- 
  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. +


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux