Hello 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. I can try and provide logs info etc, but hoping someone has a clue about this Thx Zahir
