From: | Michael Paquier <michael(at)paquier(dot)xyz> |
---|---|
To: | Suraj Kharage <suraj(dot)kharage(at)enterprisedb(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Catalog views failed to show partitioned table information. |
Date: | 2018-12-14 23:00:32 |
Message-ID: | 20181214230032.GB5012@paquier.xyz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2018-12-14 23:03:48 | Re: Variable-length FunctionCallInfoData |
Previous Message | Tom Lane | 2018-12-14 22:50:03 | Re: BUG #15548: Unaccent does not remove combining diacritical characters |