pg_restore -j number-of-jobs can
".. dramatically reduce the time to restore a large database to a server running on a multi-processor machine."
Our small-to-medium size database (4GB as a script dump), had been taking 90 minutes to restore. Switching from "script format" to "archive format" (
pg_dump -Fc) and restoring with
-j 2 now takes 45 minutes.