Re: Improving pg_dump performance when handling large numbers of LOBs

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Re: Improving pg_dump performance when handling large numbers of LOBs
Дата
Msg-id VisenaEmail.39.b34e62cb86518e81.18d7aded876@origo-test01.app.internal.visena.net
обсуждение исходный текст
Ответ на Re: Improving pg_dump performance when handling large numbers of LOBs  (Wyatt Tellis <wyatt.tellis@gmail.com>)
Ответы Re: Improving pg_dump performance when handling large numbers of LOBs
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

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