Обсуждение: Re: [GENERAL] Joins and links

Leon wrote:
>
> Ah, you mean MVCC! That's what I replied to Tom Lane:
>
> > This problem can be solved. An offhand solution is to have
> > an additional system field which will point to new tuple left after
> > update. It is filled at the same time as the original tuple is
> > marked invalid.  So the scenario is as follows: we follow the link,
> > and if we find that in the tuple where we arrived this system field
> > is not NULL, we go to (the same table of course) where it is pointing
> > to. Sure VACUUM will eliminate these. Performance penalty is small.

Old tuple version points to new version right now -:).
O how else could we handle updates in read committed mode
(new tuple version are not visible to concurrent update).

Let's go to hackers list.
But also let's relax for some more time, Leon... -:)

Vadim