On 5/31/20 1:13 PM, Christophe Pettus wrote:
On May 31, 2020, at 13:10, [email protected] wrote:
On 2020-05-31 13:08, Christophe Pettus wrote:
On May 31, 2020, at 08:05, [email protected] wrote:
My pg_class table contains 9,000,000 entries and I have 9004 schema.
Which version of pg_dump are you running? Older versions (don't have
the precise major version in front of me) have N^2 behavior on the
number of database objects being dumped.
I am upgrading from 9.3
To which version? You might try the dump with the version of pg_dump
corresponding to the PostgreSQL version you are upgrading *to* (which is
recommended practice, anyway) to see if that improves matters.
Just a reminder that the OP's original issue was with using pg_upgrade.
--
-- Christophe Pettus
[email protected]
--
Adrian Klaver
[email protected]
