4 ms·
I believe most major versions of postgres only change metadata, so the downtime only scales with the size of the schema (usually small) and not the size of the
by CodesInChaos 2mo ago
I believe most major versions of postgres only change metadata, so the downtime only scales with the size of the schema (usually small) and not the size of the data.
- pritambaral 2mo agoNote: this only applies if the `--link` flag is used with `pg_upgrade` (which, I recommend), but the default is to copy all data.
- CodesInChaos 2mo agoAssuming you're on a filesystem that supports reflinks (Btrfs, XFS), `--clone` is an interesting option as well. Though assuming you create a volume backup before starting migration, hardlinks don't really have downsides and will probably have better performance after the upgrade since the avoid copy-on-write.