Add Index-level REINDEX with multiple jobs - Mailing list pgsql-hackers

From Maxim Orlov
Subject Add Index-level REINDEX with multiple jobs
Date
Msg-id CACG=ezZU_VwDi-1PN8RUSE6mcYG+Yx1NH_rJO4+Ke-mKqLp=Nw@mail.gmail.com
Whole thread Raw
Responses Re: Add Index-level REINDEX with multiple jobs
List pgsql-hackers
Hi!

Recently, one of our customers came to us with the question: why do reindex utility does not support multiple jobs for indices (-i opt)?
And, of course, it is because we cannot control the concurrent processing of multiple indexes on the same relation.  This was
discussed somewhere in [0], I believe.  So, customer have to make a shell script to do his business and so on.

But. This seems to be not that complicated to split indices by parent tables and do reindex in multiple jobs?  Or I miss something?
PFA patch implementing this.

As always, any opinions are very welcome!


--
Best regards,
Maxim Orlov.
Attachment

pgsql-hackers by date:

Previous
From: Maxim Orlov
Date:
Subject: Next step towards 64bit XIDs: Switch to FullTransactionId for PGPROC->xid and XLogRecord->xl_xid
Next
From: Tomas Vondra
Date:
Subject: Re: Fix Brin Private Spool Initialization (src/backend/access/brin/brin.c)