čt 29. 11. 2018 v 7:58 odesílatel Michael Paquier <mich...@paquier.xyz> napsal:
> 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 :) > any time, the behave should be consistent. I agree, so there can be another patch, that reports more about partitioned table for \d+ > 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. > ok - \dpi and \dpt for respectively partitioned indexes and tables. > -- > Michael >
