Add support for --jobs in reindexdb

Michael Paquier <michael@paquier.xyz>

Commit: 5ab892c391c6bc54a00e7a8de5cab077cabace6a
Author: Michael Paquier <michael@paquier.xyz>
Date: 2019-07-27T13:21:18Z
Releases: 13.0
Add support for --jobs in reindexdb

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

Files

PathChange+/−
doc/src/sgml/ref/reindexdb.sgml modified +23 −0
src/bin/scripts/Makefile modified +1 −1
src/bin/scripts/reindexdb.c modified +365 −51
src/bin/scripts/t/090_reindexdb.pl modified +43 −1

Documentation touched

Discussion