• Peter Eisentraut's avatar
    REINDEX CONCURRENTLY · 5dc92b84
    Peter Eisentraut authored
    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.
    
    Author: Michael Paquier, Andreas Karlsson, Peter Eisentraut
    Reviewed-by: Andres Freund, Fujii Masao, Jim Nasby, Sergei Kornilov
    Discussion: https://www.postgresql.org/message-id/flat/60052986-956b-4478-45ed-8bd119e9b9cf%402ndquadrant.com#74948a1044c56c5e817a5050f554ddee
    5dc92b84
dependency.h 8.66 KB