Postgres Pro
Downloads
Home   >   mailing lists

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

From Christophe Pettus
Subject Re: pg_dump of database with numerous objects
Date
Msg-id 00424372-5321-4183-9CBB-BBFC8585ECE7@thebuild.com
Whole thread Raw
In response to pg_dump of database with numerous objects  (tony@exquisiteimages.com)
Responses Re: pg_dump of database with numerous objects  (tony@exquisiteimages.com)
List pgsql-general
Tree view 

> 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^2behavior on the number of database objects being dumped. 

--
-- Christophe Pettus
   xof@thebuild.com

pgsql-general by date:

Previous
From: tony@exquisiteimages.com
Date:
Subject: Re: pg_dump of database with numerous objects
Next
From: "Andrus"
Date:
Subject: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated