Re: Horribly slow pg_upgrade performance with many Large Objects

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Horribly slow pg_upgrade performance with many Large Objects
Дата
Msg-id CAMT0RQQFZHZvftObnG9OAHE=bOhuVA_ymp6pG+dLfS66o-EGNA@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
Re: Horribly slow pg_upgrade performance with many Large Objects
Список pgsql-hackers
On Tue, Apr 8, 2025 at 8:39 PM Nathan Bossart <nathandbossart@gmail.com> wrote:
>
...
>
> I've also verified that the dependency information is carried over in
> upgrades to later versions (AFAICT all the supported ones).

If I remember correctly the change to not copying
pg_largeobject_metadata data file but instead moving LOs as part of
schema was done in v12 when oid,, which had been a system column in
v11, became a user column, so upgrade to v11 is likely also missing
the dependencies



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