Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
Date: 2020-12-19 17:48:13
Message-ID: CAGnEbohv+LAUqGFK3uvfL-rOXa7QvNwgdmoYwgaXHrPrFv0BQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

сб, 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-12-19 17:57:41 Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
Previous Message Andrey Borodin 2020-12-19 17:25:22 Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data