What issues could arise after upgrading PostgreSQL from 9.4 to 9.6 [closed]

Posted: asked May 19 at 7:43 - Source : stackoverflow

I am about to upgrade a database installation from PostgreSQL 9.4 to 9.6, mainly because of multithreading in the query engine (we hope to gain performance). I know how to upgrade.

Thing is, the application is quite heavy on pgpsql code. Almost all functionality of the system is coded in the database.

Are there any problems that could arise from the upgrade? Is there anything to look out for in the code to do extra tests or perhaps refactor?