> Thanks! Since you mentioned that you have multiple databases with 1M+ > databases, you might also be interested in commit 2329cad. That should > speed up the pg_dump step quite a bit. Wow, I noticed this commit(2329cad) when it appeared in commitfest. It has doubled the speed of pg_dump in this scenario. Thank you for your effort!
Besides, https://commitfest.postgresql.org/48/4995/ seems insufficient to this situation. Some time-consuming functions like check_for_data_types_usage are not yet able to run in parallel. But these patches could be a great starting point for a more efficient parallelism implementation. Maybe we can do it later.
