Re: pg_dump of database with numerous objects

From: tony(at)exquisiteimages(dot)com
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump of database with numerous objects
Date: 2020-05-31 20:10:12
Message-ID: ae8645ed93326a2be802b87bd33cc4fc@exquisiteimages.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2020-05-31 13:08, Christophe Pettus wrote:
>> On May 31, 2020, at 08:05, tony(at)exquisiteimages(dot)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

>
> --
> -- Christophe Pettus
> xof(at)thebuild(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2020-05-31 20:13:57 Re: pg_dump of database with numerous objects
Previous Message Paul Förster 2020-05-31 20:01:43 Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated