On Wed, 2024-10-23 at 04:47 +0200, Laurenz Albe wrote: > On Tue, 2024-10-22 at 10:41 -0700, Jeff Davis wrote: > > I attached a patch that creates partitioned tables with relpages=- > > 1, > > and updates the docs. > > Does this need any changes for pg_upgrade?
pg_upgrade would go through the same DDL path, so I expect it would be set to -1 in the upgraded cluster anyway. Are you seeing something different? In any case, the change is just meant to improve consistency and documentation. I didn't intend to create a hard guarantee that it would always be -1, so perhaps I should make the documentation more vague with "may be" instead of "is"? It bothers me somewhat that views still have relpages=0, because they also don't have storage. Thoughts? Regards, Jeff Davis