From: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
---|---|
To: | Mathias Brossard <mathias(at)brossard(dot)org>, pavel(dot)stehule(at)gmail(dot)com |
Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: ToDo: show size of partitioned table |
Date: | 2018-10-30 06:51:46 |
Message-ID: | 96c3a19b-ffff-d1f7-ac44-52bfffc43bb7@lab.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Mathias, Pavel,
On 2018/08/17 12:26, Mathias Brossard wrote:
> On Thu, Aug 16, 2018 at 12:46 AM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
>>
>> This is question - maybe we can support older partitioning based on only
>> inheritance - and the query can be more exact on PostgreSQL 10 and newer.
>>
>> Please, send any patch. You are welcome.
>
> In my very humble opinion, I would restrict the definition of partitions to
> declarative partitioning. My justification would be that partitions all use
> inheritance, but not all inheritance is a partition (how would you handle
> multiple inheritance).
>
> See patch attached that fails (in a way similar to other features) when
> connected to servers with version earlier than 10.0.
The patch to add the pg_partition_tree() function was just committed:
Add pg_partition_tree to display information about partitions
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d5eec4eefde70
Could one of you please revise the patch to use that function to produce
the output of \dP+?
Note that pg_partition_tree simply scans the underlying catalog to get all
the tables, so if you pass it a table that's not partitioned (relkind ==
'r'), but has inheritance children, the children will be returned in its
output. So, if you want to limit the output of \dP to partitioned tables,
be sure to include relkind = 'p' condition in the query.
Thanks,
Amit
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Langote | 2018-10-30 07:30:22 | Re: Should pg 11 use a lot more memory building an spgist index? |
Previous Message | Tsunakawa, Takayuki | 2018-10-30 06:24:48 | RE: [PROPOSAL]a new data type 'bytea' for ECPG |