> On May 31, 2020, at 13:10, tony@xxxxxxxxxxxxxxxxxxx wrote: > > On 2020-05-31 13:08, Christophe Pettus wrote: >>> On May 31, 2020, at 08:05, tony@xxxxxxxxxxxxxxxxxxx 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. -- -- Christophe Pettus xof@xxxxxxxxxxxx
