Re: "Routine Reindexing" docs should be updated to reference REINDEX CONCURRENTLY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "Routine Reindexing" docs should be updated to reference REINDEX CONCURRENTLY
Дата
Msg-id 7959.1556290415@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: "Routine Reindexing" docs should be updated to reference REINDEXCONCURRENTLY  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: "Routine Reindexing" docs should be updated to reference REINDEXCONCURRENTLY  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Michael Paquier <michael@paquier.xyz> writes:
> On Thu, Apr 25, 2019 at 01:34:41PM -0700, Peter Geoghegan wrote:
>> The documentation has a section called "Routine Reindexing", which
>> explains how to simulate REINDEX CONCURRENTLY with a sequence of
>> creation and replacement steps. This should be updated to reference
>> the REINDEX CONCURRENTLY command.

> Agreed, good catch.  I would suggest to remove most of the section and
> just replace it with a reference to REINDEX CONCURRENTLY, as per the
> attached.  What do you think?

+1.  Maybe say "... which requires only a
<literal>SHARE UPDATE EXCLUSIVE</literal> lock."

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6
Следующее
От: Tom Lane
Дата:
Сообщение: Re: findTargetlistEntrySQL92() and COLLATE clause