REFERENCES ADJACENT Nodes(id),
target INTEGER REFERENCES Nodes(id)
);
would suffice for this new semantics.
--
Dilshod Urazov
new index entry for the
> new HOT-chain's TID.
If test'b column was updated and HOT optimization took place no new index
entry is created. Index tuple
pointing to old heap tuple is valid since now it is pointing to HOT-chain.
--
Dilshod Urazov
пн, 19 февр. 2024 г. в 22:32, Ma
> only 1 index lookup is needed.
Sorry, must be "only lookups of 1 index are needed".
--
Dilshod Urazov
вт, 20 февр. 2024 г. в 21:09, Dilshod Urazov :
> > I'm not sure why are two indexes not sufficient here?
>
> Did I write that they are not sufficient? The whole