News for hackers. Stuff that matters.
Re:PostgreSQL upgrades are hard by nicoburns on Saturday June 25, 2022 @03:44PM (#31878120)
I think the issue is if you want zero-downtime (or close to zero downtime). pg_upgrade can take upwards of 10 minutes to run even for relatively small databases. It can potentially be hours for large ones.
Re:PostgreSQL upgrades are hard by aidos on Sunday June 26, 2022 @06:37AM (#31882662)
If you use —-link it uses the existing data files instead of copying, which is significantly faster (though I’m not sure what your definition of relatively small is).