Re: pgsql: REINDEX CONCURRENTLY

2019-03-29 Thread Michael Paquier
Hi Peter, On Fri, Mar 29, 2019 at 07:26:53AM +, Peter Eisentraut wrote: > REINDEX CONCURRENTLY > > This adds the CONCURRENTLY option to the REINDEX command. A REINDEX > CONCURRENTLY on a specific index creates a new index (like CREATE > INDEX CONCURRENTLY), then renames the old index away an

pgsql: REINDEX CONCURRENTLY

2019-03-29 Thread Peter Eisentraut
REINDEX CONCURRENTLY This adds the CONCURRENTLY option to the REINDEX command. A REINDEX CONCURRENTLY on a specific index creates a new index (like CREATE INDEX CONCURRENTLY), then renames the old index away and the new index in place and adjusts the dependencies, and then drops the old index (li