čt 29. 11. 2018 v 7:58 odesílatel Michael Paquier <michael@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.
