Re: Antonio Terceiro > In the past, I hit a case where upgrading a cluster with a Very Large™ > database via dump/restore took a Very Long™ time. Back then I discovered > --method=upgrade, and that's what I have been using since. > > Is there anything stopping this from being made the default?
Hi, I sympathize with the idea, but there is a detail that makes dump-restore more attractive: operating system upgrades will bring new versions of libc and libicu, and these dictate how indexes are sorted on disk. This ordering can change when the libraries are upgraded, and then indexes need to be rebuilt. Dump-restore does rebuild indexes, pg_upgrade does not. PostgreSQL will also pester the user about that, since around PG14, the library version used to create an index is recorded. I'd prefer the default upgrade mode to fix that, so we should stick to --method=dump. We can add a note to README.Debian, though. Christoph
