Re: pg_upgrade too slow on vacuum phase

2020-05-14 Thread Kouber Saparev
> > 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

Re: pg_upgrade too slow on vacuum phase

2020-05-12 Thread Adrian Klaver
On 5/12/20 5:27 AM, Kouber Saparev wrote: I am trying to upgrade PostgreSQL from 9.5 to 12 using pg_upgrade. /usr/lib/postgresql/12/bin/pg_upgrade \   --old-datadir=/var/lib/postgresql/9.5/main \   --new-datadir=/var/lib/postgresql/12/main \   --old-bindir=/usr/lib/postgresql/9.5/bin \   --n