4 ms·
>that is proportional to the size of the data I agree upgrades are still a pain point, but pg_upgrade running time is not proportional to the size of the data.
by uhoh-itsmaciek 6y ago
>that is proportional to the size of the data
I agree upgrades are still a pain point, but pg_upgrade running time is not proportional to the size of the data.
- spapas82 6y agoMaybe i didn't express myself clearly (english is not my primary language) but since with pg_upgrade the data will be copied from the old cluster to the new one, doing an upgrade to a 10GB database would need ~ 10 times more than upgrading a 1 GB database, just for the data copying. So the time will be proportional to the size of the data.
- uhoh-itsmaciek 6y agoI see, that's a good point: I'm used to pg_upgrade in --link mode, but if you want to be safe and have an isolated old cluster around, you're right: you'll still need to copy the data. Thanks for clarifying.