From: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
To: Marc Mamin <M.Mamin@intershop.de>
To: Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Declarative partitioning
Date: Wed, 19 Aug 2015 17:03:12 +0900
Message-ID: <55D43840.5030504@lab.ntt.co.jp> (raw)
In-Reply-To: <B6F6FD62F2624C4C9916AC0175D56D8828C1FA5A@jenmbs01.ad.intershop.net>
References: <55D3093C.5010800@lab.ntt.co.jp>
<B6F6FD62F2624C4C9916AC0175D56D8828C1FA5A@jenmbs01.ad.intershop.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
On 2015-08-19 AM 02:57, Marc Mamin wrote:
>> 2. Creating a partition of a partitioned table
>>
>> CREATE TABLE table_name
>> PARTITION OF partitioned_table_name
>> FOR VALUES values_spec;
>>
>> Where values_spec is:
>>
>> listvalues: [IN] (val1, ...)
>>
>
> Would it make sense to allow one complementary partition to the listvalues?
>
> listvalues: [[NOT] IN] (val1, ...)
>
> I've thought a few times about moving data with some most common values to dedicated partitions
> and keeping the rest in a separate one...
>
Thanks, that's definitely something to consider.
I have been thinking of a sort of default list partition for the "rest" of
values. Would you rather declare that with something like the below than
having to enumerate all the values in a NOT IN list? Or the NOT IN way is
more intuitive/friendly?
CREATE TABLE _rest PARTITION OF table_name FOR VALUES [ IN ] DEFAULT
Of course, at most one such partition would be allowed.
Thanks,
Amit
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: Langote_Amit_f8@lab.ntt.co.jp, M.Mamin@intershop.de
Subject: Re: Declarative partitioning
In-Reply-To: <55D43840.5030504@lab.ntt.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox