Search Postgresql Archives

Re: PG10 upgrade issue

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

 



Zahir Lalani <ZahirLalani@oliver.agency> writes:
> We have done pg10 upgrades from 9.6 on all our environments successfully. We have an automation script that does this for us. One environment is a near replica of our production setup and all works fine.

> We have now made 2 attempts at doing this on production - both ending up with rollback

> The key issue we have is that all queries were incredibly slow. The PG 10 postmaster workers would all show 100% cpu, especially on the replicas. We even increased CPUs but that made no difference.

Did you make sure to rebuild statistics (re-ANALYZE) after the upgrade?
pg_upgrade makes a script for that, but I don't believe it runs it for
you.

			regards, tom lane






[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