senor <frio_cervesa@xxxxxxxxxxx> writes: > I know from a previous post to the community that pg_dump --schema-only is single threaded and the --jobs option cannot benefit pg_dump in my case (single DB, Single schema, 100000+ tables). Using pg_upgrade with the --link option is very fast 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
