Improving pg_dump performance when handling large numbers of LOBs

Поиск
Список
Период
Сортировка
От Wyatt Tellis
Тема Improving pg_dump performance when handling large numbers of LOBs
Дата
Msg-id CANCMp8yTnRrVtEQnMMfxw_pxRSXsv40TWFUbnaR4rvDnBzJ2eg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Improving pg_dump performance when handling large numbers of LOBs
Список pgsql-general
Hi,

We've inherited a series of legacy PG 12 clusters that each contain a database that we need to migrate to a PG 15 cluster. Each database contains about 150 million large objects totaling about 250GB. When using pg_dump we've found that it takes a couple of weeks to dump out this much data.  We've tried using the jobs option with the directory format but that seems to save each LOB separately which makes moving the resulting dump to another location unwieldy.  Has anyone else had to deal with dumping a database with these many LOBs?  Are there any suggestions for how to improve performance?

Thanks,

Wyatt

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

Предыдущее
От: veem v
Дата:
Сообщение: Re: Question on partitioning
Следующее
От: veem v
Дата:
Сообщение: Re: How to do faster DML