Hacker News new | past | comments | ask | show | jobs | submit login

Wondering why you couldn’t use in-place upgrade (pg_upgrade [0]). Not supported in Azure?

[0] https://www.postgresql.org/docs/current/pgupgrade.html




I'm guessing this would still take more than one hour since it needs to rewrite all (or most) of the 4TB?


Not in my experience. You can use the —-link flag to get it to use hard links so it doesn’t need to move the data at all. Have been through this process myself a few times and it only took seconds on a 50-100GB db. I’m always a little surprised with how week it works.


Exactly, it just has to touch the metadata, unless the data page format has changed, which the developers try hard to avoid (successfully so far).




Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: