Skip site navigation (1) Skip section navigation (2)

Re: CTID issues and a soc student in need of help

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tzahi Fadida <tzahi(dot)ml(at)gmail(dot)com>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CTID issues and a soc student in need of help
Date: 2006-06-01 15:28:09
Message-ID: 12644.1149175689@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Tzahi Fadida <tzahi(dot)ml(at)gmail(dot)com> writes:
> I am using CTID for the concept of a tuple set.
> For example, the set of t1 from relation1, t1 from relation2, t10 from
> relation3 will be represented in my function as a list
> of (TableID:CTID) pairs.
> For example {(1:1),(2:1),(3:10))
> I then save these in bytea arrays in a tuplestore.
> This is essential for the full disjunction algorithm because
> you do not want to recompute joins for every such set using the actual
> attribute.

I think this is OK within the context of a single SQL command, since
tuple visibility should not change for that command.  If you were trying
to use the CTID info across multiple statements then it'd get worrisome.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tzahi FadidaDate: 2006-06-01 15:57:53
Subject: Re: CTID issues and a soc student in need of help
Previous:From: Tzahi FadidaDate: 2006-06-01 15:17:44
Subject: Re: CTID issues and a soc student in need of help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group