Re: pg_dump of database with numerous objects

Поиск
Список
Период
Сортировка
От tony@exquisiteimages.com
Тема Re: pg_dump of database with numerous objects
Дата
Msg-id ae8645ed93326a2be802b87bd33cc4fc@exquisiteimages.com
обсуждение исходный текст
Ответ на Re: pg_dump of database with numerous objects  (Christophe Pettus <xof@thebuild.com>)
Ответы Re: pg_dump of database with numerous objects
Список pgsql-general
Дерево обсуждения 
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


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

В списке pgsql-general по дате отправления:

Предыдущее
От: Paul Förster
Дата:
Сообщение: Re: How to start slave after pg_basebackup. Why min_wal_size andwal_keep_segments are duplicated
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: pg_dump of database with numerous objects