"Cary O'Brien" <cobrien@Radix.Net> writes:
> What I meant to say, and failed, was that in Oracle, rowid
> "psuedo-column" are hex encoded strings containing the block, row, and
> file where the tuple is stored. So lookup on unindexed rowid *should*
> be fast, although this is not spelled out in my ancient Oracle book.
Oh, in that case it's pretty much like our CTID column. For example:
regression=# select ctid,* from int8_tbl where ctid = '(0,3)';
ctid | q1 | q2
-------+------------------+-----
(0,3) | 4567890123456789 | 123
(1 row)
There is some code in 7.0 that tries to implement this in a fast way,
but I don't know how well it works...
regards, tom lane