Re: Concurrency issue with DROP INDEX CONCURRENTLY

2023-02-09 Thread Kiriakos Georgiou
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 >

Concurrency issue with DROP INDEX CONCURRENTLY

2023-02-09 Thread Kiriakos Georgiou
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 index idx1 on test(x); — now suppose with the d