Ron <ronljohnsonjr@xxxxxxxxx> writes: > On 4/28/19 3:21 PM, senor wrote: >> I see only one CPU of 32 doing anything and it's often at 100%. Disk IO >> is minimal. Memory use varies but always plenty to spare. > "pg_dump --schema-only" is single-threaded. Yup. But ... pg_upgrade does have a --jobs option, since 9.5 or so. What it does is to run the dump and restore tasks for different databases of the cluster in parallel. So it won't help much if you've just got one DB with a lotta objects, but I thought it was worth mentioning. regards, tom lane
