Re: pg_dump of database with numerous objects

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: pg_dump of database with numerous objects
Дата
Msg-id 00424372-5321-4183-9CBB-BBFC8585ECE7@thebuild.com
обсуждение исходный текст
Ответ на pg_dump of database with numerous objects  (tony@exquisiteimages.com)
Ответы Re: pg_dump of database with numerous objects
Список pgsql-general
Дерево обсуждения 

> 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 по дате отправления:

Предыдущее
От: tony@exquisiteimages.com
Дата:
Сообщение: Re: pg_dump of database with numerous objects
Следующее
От: "Andrus"
Дата:
Сообщение: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated