Re: Improving pg_dump performance when handling large numbers of LOBs

Поиск
Список
Период
Сортировка
От Wyatt Tellis
Тема Re: Improving pg_dump performance when handling large numbers of LOBs
Дата
Msg-id CANCMp8yc7PBucRekbL1SGPXSAHkxRct_ntUJzTXTiMvosM6k2w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Improving pg_dump performance when handling large numbers of LOBs  (Andreas Joseph Krogh <andreas@visena.com>)
Ответы Re: Improving pg_dump performance when handling large numbers of LOBs
Список pgsql-general
Дерево обсуждения
No, we don't have the ability to make schema changes and the schema in the PG15 copy needs to match what's in the PG 12 versions

Wyatt

On Mon, Feb 5, 2024 at 12:05 PM Andreas Joseph Krogh <andreas@visena.com> wrote:
På mandag 05. februar 2024 kl. 20:55:43, skrev Wyatt Tellis <wyatt.tellis@gmail.com>:

Yes, the LOBs themselves are tiny, but there are a lot of them (~150 million) which seem to be slowing down pg_dump.  Note, we did not design/build this system and agree that use of LOBs for this purpose was not necessary.

Well, the data is there nonetheless, is it an option to convert it to bytea before migration?

 

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Вложения

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

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Improving pg_dump performance when handling large numbers of LOBs
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Improving pg_dump performance when handling large numbers of LOBs