senor <frio_cervesa@hotmail.com> writes:
> I know from a previous post to the community that pg_dump --schema-only is single threaded and the --jobs option
cannotbenefit pg_dump in my case (single DB, Single schema, 100000+ tables). Using pg_upgrade with the --link option is
veryfast except for the pg_dump portion of the upgrade which takes days.
One simple question is whether the source server is the last available
minor release (9.2.24 I believe). If not, you may be missing performance
fixes that would help. pg_dump -s on 100K tables should not take "days",
so I'm guessing you're hitting some O(N^2) behavior somewhere, and it
might be something we fixed.
Likewise make sure that pg_dump is the newest available in the destination
release series.
regards, tom lane