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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
