pg_upgrade: the tricky and dangerous parts
Postgres FM
00:00
The Problem With Automating the Process Involving Logical and Run Postgres Measure Upgrade
In new cluster after PGA grade, we don't have statistics, so we need to run analyze. I would say it's not a good idea to run analyze right away. We can start logical first and run analyze logical subscription first. But if order of actions logical first, then upgrade and continue logical, there are risks of corruption. If you have a really big database, probably we still won't work well.
Transcript
Play full episode
