Hi Peter, On Fri, Mar 29, 2019 at 07:26:53AM +0000, 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 and the new index > in place and adjusts the dependencies, and then drops the old > index (like DROP INDEX CONCURRENTLY). The REINDEX command also has > the capability to run its other variants (TABLE, DATABASE) with the > CONCURRENTLY option (but not SYSTEM). > > The reindexdb command gets the --concurrently option.
A couple of buildfarm members using clang are not happy with this commit: REINDEX SCHEMA CONCURRENTLY schema_to_reindex; +WARNING: you don't own a lock of type ShareUpdateExclusiveLock For example longfin and dragonet: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dragonet&dt=2019-03-29%2007%3A28%3A01 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=longfin&dt=2019-03-29%2007%3A29%3A04 I cannot dig into that myself now unfortunately.. -- Michael
signature.asc
Description: PGP signature
