Database statistics are not preserved across pg_upgrade so you'll have to run ANALYZE on the database after the upgrade which may take a while as it usually needs to read all or almost all of your data.
I just recently upgraded a ~1 TB database, the actual upgrade process took less than a minute but analyzing it took much longer.
So your having to Google for five minutes when doing a major version upgrade is the biggest flaw in modern postgres? Oh come on now.
P.S. pg_upgradecluster in Debian would probably do this for you without googling
That being said, if upgrade is the biggest problem, that's great news!
I am sorry you got downvoted, but as you can see, it is a genuine pain that software should do for us. On other hand, PG is fantastic DB and it is great I have this as a problem.
If there is one feature I wish PG had, it is recognizing old format db and offering one command that can in place upgrade damn db, without me googling it every time.