Revert "Make parallel REINDEX CONCURRENTLY operations fail without deadlock"

This reverts commit 8887fdc360fb0910bce28187408c433ab5835ba2.