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 по дате отправления:

Предыдущее
От: Andy Fan
Дата:
Сообщение: Re: Check what has been done for a uncommitted prepared transaction
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Clarification related to BDR