• Michael Paquier's avatar
    Add support for --jobs in reindexdb · 5ab892c3
    Michael Paquier authored
    When doing a schema-level or a database-level operation, a list of
    relations to build is created which gets processed in parallel using
    multiple connections, based on the recent refactoring for parallel slots
    in src/bin/scripts/.  System catalogs are processed first in a
    serialized fashion to prevent deadlocks, followed by the rest done in
    parallel.
    
    This new option is not compatible with --system as reindexing system
    catalogs in parallel can lead to deadlocks, and with --index as there is
    no conflict handling for indexes rebuilt in parallel depending in the
    same relation.
    
    Author: Julien Rouhaud
    Reviewed-by: Sergei Kornilov, Michael Paquier
    Discussion: https://postgr.es/m/CAOBaU_YrnH_Jqo46NhaJ7uRBiWWEcS40VNRQxgFbqYo9kApUsg@mail.gmail.com
    5ab892c3
reindexdb.sgml 13.4 KB