Hi, On 2021-05-27 17:00:23 -0400, Bruce Momjian wrote: > If you go in that direction, you should make sure pg_upgrade preserves > what you use (it does not preserve relfilenode, just pg_class.oid)
Is there a reason for pg_upgrade not to maintain relfilenode, aside from implementation simplicity (which is a good reason!). The fact that the old and new clusters have different relfilenodes does make inspecting some things a bit harder. It'd be harder to adjust the relfilenode to match between old/new cluster if pg_upgrade needed to deal with relmapper using relations (i.e. ones where pg_class.relfilenode isn't used because they need to be accessed to read pg_class, or because they're shared), but it doesn't need to. Greetings, Andres Freund
