Re: [HACKERS] New partitioning - some feedback - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [HACKERS] New partitioning - some feedback
Date
Msg-id CANP8+jLRtpp-C0gtxO2HZ+53PKtUAfFgRwKD8f4uEycKMU2mTA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] New partitioning - some feedback  (Michael Banck <michael.banck@credativ.de>)
List pgsql-hackers
On 7 July 2017 at 08:54, Michael Banck <michael.banck@credativ.de> wrote:
> On Fri, Jul 07, 2017 at 07:40:55PM +1200, Mark Kirkwood wrote:
>> On 07/07/17 13:29, Amit Langote wrote:
>> >Someone complained about this awhile back [1].  And then it came up again
>> >[2], where Noah appeared to take a stance that partitions should be
>> >visible in views / output of commands that list "tables".
>> >
>> >Although I too tend to prefer not filling up the \d output space by
>> >listing partitions (pg_class.relispartition = true relations), there
>> >wasn't perhaps enough push for creating a patch for that.  If some
>> >committer is willing to consider such a patch, I can make one.
>>
>> Yeah, me too (clearly). However if the consensus is that all these partition
>> tables *must* be shown in \d output, then I'd be happy if they were
>> identified as such rather than just 'table' (e.g 'partition table').
>
> +1.

+1 to remove partitions from \d display

With 1000 partitions that would just be annoying

-- 
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] [WIP] Zipfian distribution in pgbench
Next
From: Magnus Hagander
Date:
Subject: Re: [HACKERS] Fix header comment of streamutil.c