On Sun, 28 Nov 2004 16:52:47 -0500, Tom Lane wrote:
> CTID (block # + line #) is the only valid pointer from an index to a
> table.
Thanks.
> I think
> though that you'd be making a serious mistake by not duplicating the
> suffixes into the index (rather than expecting to retrieve them from the
> table every time, as you seem to be contemplating).
Yes, I've thought about this, and I may end up doing that.
> You need to be able
> to scan the index and identify rows matching a query without making lots
> of probes into the table.
But is it cheaper, IO-wise to "jump" around in an index than to go back
and forth between index and tuple blocks?
--
Greetings from Troels Arvin, Copenhagen, Denmark