Re: pg_upgrade failing for 200+ million Large Objects

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: pg_upgrade failing for 200+ million Large Objects
Дата
Msg-id A975B443-F7D3-45BB-925B-FF1CF649DB54@anarazel.de
обсуждение исходный текст
Ответ на Re: pg_upgrade failing for 200+ million Large Objects  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

On November 9, 2023 10:41:01 AM PST, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>Also, pg_upgrade is often invoked indirectly via scripts, so I do
>not especially buy the idea that we're going to get useful control
>input from some human somewhere.  I think we'd be better off to
>assume that pg_upgrade is on its own to manage the process, so that
>if we need to switch strategies based on object count or whatever,
>we should put in a heuristic to choose the strategy automatically.
>It might not be perfect, but that will give better results for the
>pretty large fraction of users who are not going to mess with
>weird little switches.

+1 - even leaving everything else aside, just about no user would know about the option. There are cases where we can't
dobetter than giving the user control, but we are certainly adding options at a rate that doesn't seem sustainable. And
hereit doesn't seem that hard to do better.  

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: speed up a logical replica setup
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: pg_walfile_name_offset can return inconsistent values