On Thu, Nov 22, 2018 at 03:47:11PM +0100, Pavel Stehule wrote: > I have not feel well when I see in one report numbers 40 and 16, I see much > more comfortable when I see 24 and 16, but for this I need a different > perspective > > What do you think about it?
Maybe, my thought is that this would be a separate patch, and that we had better keep it simple for now because that's complicated enough :) So I would rather have a wrapper on top of pg_partition_tree which is useful for the user with matching patterns, which shows roughly: - the size of the whole partition tree from the root. - its direct parent if any. Potentially in the verbose output. This depends on how much users have multi-level partitions. My bet would be not that much, but more input from others is welcome. - perhaps its level in the hierarchy, if integrated most likely as part of the verbose output. Then with the set of commands, have a mapping close to how \d treats indexes and relations: - \dp shows information about partitioned tables or indexes, if no pattern is defined tables show up. If a partitioned index pattern shows up, then index information is displayed. - \dpi and \dpt for respectively partitioned indexes and tables. -- Michael
signature.asc
Description: PGP signature
