Re: pg_dump of database with numerous objects - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_dump of database with numerous objects
Date
Msg-id 0a4039bb-bd35-d079-f124-61c4d91a81de@aklaver.com
Whole thread Raw
In response to Re: pg_dump of database with numerous objects  (Christophe Pettus <xof@thebuild.com>)
Responses Re: pg_dump of database with numerous objects
List pgsql-general
On 5/31/20 1:13 PM, Christophe Pettus wrote:
> 
> 
>> 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.
 

Just a reminder that the OP's original issue was with using pg_upgrade.


> 
> --
> -- Christophe Pettus
>     xof@thebuild.com
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: pg_dump of database with numerous objects
Next
From: Christophe Pettus
Date:
Subject: Re: pg_dump of database with numerous objects