Re: pg_upgrade too slow on vacuum phase - Mailing list pgsql-general

From Kouber Saparev
Subject Re: pg_upgrade too slow on vacuum phase
Date
Msg-id CAN4RuQvMYxGrTtCtdgvS9ThthiA09XaxD=qVnr5=7LJz1cXOzg@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade too slow on vacuum phase  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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 by date:

Previous
From: Andy Fan
Date:
Subject: Re: Check what has been done for a uncommitted prepared transaction
Next
From: Simon Riggs
Date:
Subject: Re: Clarification related to BDR