Re: Reducing connection overhead in pg_upgrade compat check phase

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: Reducing connection overhead in pg_upgrade compat check phase
Дата
Msg-id 20230217230451.GD3217365@nathanxps13
обсуждение исходный текст
Ответ на Reducing connection overhead in pg_upgrade compat check phase  (Daniel Gustafsson <daniel@yesql.se>)
Список pgsql-hackers
On Fri, Feb 17, 2023 at 10:44:49PM +0100, Daniel Gustafsson wrote:
> In the trivial case, a single database, I don't see a reduction of performance
> over the current approach.  In a cluster with 100 (empty) databases there is a
> ~15% reduction in time to run a --check pass.  While it won't move the earth in
> terms of wallclock time, consuming less resources on the old cluster allowing
> --check to be cheaper might be the bigger win.

Nice!  This has actually been on my list of things to look into, so I
intend to help review the patch.  In any case, +1 for making pg_upgrade
faster.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com



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

Предыдущее
От: Nathan Bossart
Дата:
Сообщение: Re: recovery modules
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Move defaults toward ICU in 16?