Search Postgresql Archives

Re: pg_upgrade too slow on vacuum phase

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux