Re: "Routine Reindexing" docs should be updated to reference REINDEX CONCURRENTLY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: "Routine Reindexing" docs should be updated to reference REINDEX CONCURRENTLY
Date
Msg-id 7959.1556290415@sss.pgh.pa.us
Whole thread Raw
In response to Re: "Routine Reindexing" docs should be updated to reference REINDEXCONCURRENTLY  (Michael Paquier <michael@paquier.xyz>)
Responses Re: "Routine Reindexing" docs should be updated to reference REINDEXCONCURRENTLY
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6
Next
From: Tom Lane
Date:
Subject: Re: findTargetlistEntrySQL92() and COLLATE clause