On Fri, Dec 14, 2018 at 05:21:49PM +0530, Suraj Kharage wrote:
> There are some catalog views which do not show the partitioned table and
> its index entry.
> One of them is "pg_indexes" which failed to show the partitioned index.
> Attached the patch which fixes the same.
I tend to agree with your comment here. pg_tables lists partitioned
tables, but pg_indexes is forgotting about partitioned indexes. So this
is a good thing to add.
> Other views such as pg_stat*,pg_statio_* has the same problem for
> partitioned tables and indexes.
> Since the partitioned tables and its indexes considered as a dummy, they do
> not have any significance in stat tables,
> can we still consider adding relkind=p in these pg_stat_* views? Thoughts?
I am less sure about that as partitioned relations do not have a
physical presence.
--
Michael