Re: pg_dump of database with numerous objects

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