I love postgres but every major upgrade needs weird interventions...
I love postgres but every major upgrade needs weird interventions...
Imagine there are changes to the physical format for example, now you need to make sure all code works with both the new and the old format during the upgrade (as some pages will have been updated and others not). Supporting both versions requires temporary backwards compatibility code, bloating the codebase, and introduces a risk of error and increases the complexity of the system.
Since Postgres prioritises correctness probably more than any other database system I know, I’d guess they don’t want to expose themselves to the risk of error.
It's a scale issue. If one does it for all, less work for everyone :)
For large DBs though you may not be able to wait for it to happen offline.
They just state that it is for various reasons.
And I'm not even talking about upgrading without downtime I mean the problem that you can't just replace 14 with 15 without preparing the DB upfront.