On Thu, 2023-02-09 at 10:45 -0500, Kiriakos Georgiou wrote:
> I have an interesting concurrency issue with DROP INDEX CONCURRENTLY that I
> can summarize with this test scenario:
>
> /**/
>
> — suppose we have this table and index
> create table tes
My apologies - there is no issue with DROP INDEX CONCURRENTLY.
It’s just brain fade on my part (I dropped the existing index before creating
the new UNIQUE index, causing TPS on this table to go to zero *facepalm*).
Regards,
Kiriakos
> On Feb 9, 2023, at 10:45 AM, Kiriakos Georgiou
> wrote:
On 2/9/23 07:45, Kiriakos Georgiou wrote:
Hello,
I have an interesting concurrency issue with DROP INDEX CONCURRENTLY that I can
summarize with this test scenario:
/**/
— suppose we have this table and index
create table test(x int);
create inde
