Re: Feature Request: multithreaded reindexdb --concurrently of a single table - Mailing list pgsql-admin

From Álvaro Herrera
Subject Re: Feature Request: multithreaded reindexdb --concurrently of a single table
Date
Msg-id 202502211846.grjzhouis773@alvherre.pgsql
Whole thread Raw
In response to Feature Request: multithreaded reindexdb --concurrently of a single table  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Feature Request: multithreaded reindexdb --concurrently of a single table
List pgsql-admin
On 2025-Feb-18, Ron Johnson wrote:

> It would be really really handy to be able to run multiple REINDEX INDEX
> jobs at the same time, either by just specifying the table as above and
> reindexdb automagically getting the index names, or by manually enumerating
> each index, and then see all four REINDEX INDEX statements in
> pg_stat_activity.

I don't think multiple REINDEX commands can run concurrently on the same
table, so this is not a reindexdb issue but a server issue.  And TBH I
think the server feature to support that is not likely to be implemented
soon.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Ed is the standard text editor."
      http://groups.google.com/group/alt.religion.emacs/msg/8d94ddab6a9b0ad3



pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: May data be corrupted after an interrupted, but afterwards sucessfully replayed recovery?
Next
From: Ron Johnson
Date:
Subject: Re: Feature Request: multithreaded reindexdb --concurrently of a single table