сб, 19 дек. 2020 г. в 18:13, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>:
> I observe:
> NOTICE: heap tuple (1,8) from table "t1" lacks matching index tuple
> within index "i1"
> I expect: awaiting 'x' commit before index is created, correct index after.
>
I agree, that behaviour is unexpected. But getting a notice that requires me
to re-create the index some time later is not better (from DBA perspective).
Maybe it'd be better to wait on prepared xacts like on other open ordinary
transactions?
--
Victor Yegorov