Re: pg_upgrade too slow on vacuum phase

Поиск
Список
Период
Сортировка
От Kouber Saparev
Тема Re: pg_upgrade too slow on vacuum phase
Дата
Msg-id CAN4RuQvMYxGrTtCtdgvS9ThthiA09XaxD=qVnr5=7LJz1cXOzg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_upgrade too slow on vacuum phase  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
So the analyze(and freeze) are done before the new cluster are fully
populated. Is the time being taken maybe for the loading schema/data
portion?


No, the upgrade is stuck on these 2 stages indeed, maybe 50% on the first and 50% (or a little more) on the second. When a run them outside of the pg_upgrade procedure it is still slow, so pg_upgrade is not to blame. I guess I will need to repack the biggest tables first.

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