Re: Fix reindexdb with parallel index-level conrurrent run

From: Manu <manuelreyesbravo(at)gmail(dot)com>
To: Kirill Reshke <reshkekirill(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Fix reindexdb with parallel index-level conrurrent run
Date: 2026-10-06 12:19:17
Message-ID: 179128915708.65738.8736489394727569781@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Kirill,

> I think we can indeed just drop support for parallel index-level
> concurrency index rebuild.

+1. I tested v1 on master: --concurrently --jobs at index level now
fails cleanly with "cannot use multiple jobs to reindex indexes
concurrently", while --concurrently without --jobs and table-level
--concurrently --jobs are unaffected. Reads right to me.

Regards,
Manu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zhijie Hou 2026-10-06 12:19:48 Re: Publication DDL can race with a concurrent UPDATE
Previous Message ZizhuanLiu X-MAN 2026-10-06 12:11:27 Re: Optimize MCV stats for sortable types and utilize sorted-order properties