Add Index-level REINDEX with multiple jobs

Поиск
Список
Период
Сортировка
От Maxim Orlov
Тема Add Index-level REINDEX with multiple jobs
Дата
Msg-id CACG=ezZU_VwDi-1PN8RUSE6mcYG+Yx1NH_rJO4+Ke-mKqLp=Nw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Add Index-level REINDEX with multiple jobs  (Michael Paquier <michael@paquier.xyz>)
Список 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.
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Maxim Orlov
Дата:
Сообщение: Next step towards 64bit XIDs: Switch to FullTransactionId for PGPROC->xid and XLogRecord->xl_xid
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Fix Brin Private Spool Initialization (src/backend/access/brin/brin.c)