Re: CREATE INDEX CONCURRENTLY on partitioned index

From: Ilya Gladyshev <ilya(dot)v(dot)gladyshev(at)gmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Alexander Pyhalov <a(dot)pyhalov(at)postgrespro(dot)ru>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, 李杰(慎追) <adger(dot)lj(at)alibaba-inc(dot)com>
Subject: Re: CREATE INDEX CONCURRENTLY on partitioned index
Date: 2024-06-20 19:20:58
Message-ID: e8002e5c-660b-42b0-b99d-37c3883c441f@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 15.06.2024 20:40, Justin Pryzby wrote:
> On Thu, May 23, 2024 at 10:14:57PM +0100, Ilya Gladyshev wrote:
>> Hi,
>>
>> I think it's well worth the effort to revive the patch, so I rebased it on
>> master, updated it and will return it back to the commitfest. Alexander,
>> Justin feel free to add yourselves as authors
> Thanks -- I was intending to write about this.
>
> I realized that the patch will need some isolation tests to exercise its
> concurrent behavior.

Thanks for the suggestion, added an isolation test that verifies
behaviour of partitioned CIC with simultaneous partition drop/detach
going on. Also fixed some issues in the new patch that I found while
writing the test.

Attachment Content-Type Size
v5-0002-Fix-progress-report-for-partitioned-REINDEX.patch text/x-patch 7.3 KB
v5-0001-Allow-CREATE-INDEX-CONCURRENTLY-on-partitioned-ta.patch text/x-patch 28.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2024-06-20 19:42:56 Re: DROP OWNED BY fails to clean out pg_init_privs grants
Previous Message Robert Haas 2024-06-20 19:18:49 Re: DROP OWNED BY fails to clean out pg_init_privs grants