4 ms·
Major version OSS database upgrades? I would probably never consider this a easy/low risk thing, anytime you have any planner changes its something where having
by hobs 2y ago
Major version OSS database upgrades? I would probably never consider this a easy/low risk thing, anytime you have any planner changes its something where having a baseline is really important to understand the impact to your workload.
- blackenedgem 2y agoIt's doubly bad with postgres because the statistics get wiped after running pg_upgrade. They do tell you to run ANALYZE afterwards but that's yet more downtime.
- hobs 2y agoThat's not great, do the bucket counts change or something between versions? It seems like statistics would be a thing that ... should not change while you are not looking!