Re: Horribly slow pg_upgrade performance with many Large Objects

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Horribly slow pg_upgrade performance with many Large Objects
Дата
Msg-id CAMT0RQQmc5KKCYUG4Qa1R2L-Yar=7p_pEROLrEy_SSNkG6eRNw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Horribly slow pg_upgrade performance with many Large Objects  (Nathan Bossart <nathandbossart@gmail.com>)
Ответы Re: Horribly slow pg_upgrade performance with many Large Objects
Список pgsql-hackers
Do you think the current patch could be backported to at least some
latest versions ?

On Fri, Jul 18, 2025 at 6:05 PM Nathan Bossart <nathandbossart@gmail.com> wrote:
>
> Committed.
>
> I'm cautiously optimistic that we can find some better gains for upgrades
> from v16 and newer.  That would involve dumping lo_create() commands for
> all LOs with comments/seclabels, dumping the relevant pg_shdepend rows, and
> then copying/linking the pg_largeobject_metadata files like we did prior to
> v12.
>
> --
> nathan



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