Re: AW: [HACKERS] Fwd: Joins and links

Zeugswetter Andreas IZ5 wrote:
> 
> I think the best compromise would be to have ctid in the where clause.

And we told about this a days ago, but no one did it.

> This would need to always be considered as best path by the optimizer.
> Then the situation is similar to a primary key foreign key scenario.
> 
> The referenced table does not need an index, since we know the physical
> position of the row we want (where ctid='(5,255)').
> 
> What we need second is an update trigger for the referenced table that
> updates old.ctid to new.ctid in the referencing table. For this to be

Triggers are not fired by vacuum...

Vadim