Skip site navigation (1) Skip section navigation (2)

Re: Declarative partitioning

From: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
To: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Pg Hackers<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Declarative partitioning
Date: 2015-08-18 17:57:44
Message-ID: B6F6FD62F2624C4C9916AC0175D56D8828C1FA5A@jenmbs01.ad.intershop.net (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-hackers
great :-)

>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...

best regards,

Marc Mamin


In response to

Responses

pgsql-hackers by date

Next:From: Corey HuinkerDate: 2015-08-18 17:59:41
Subject: Re: Declarative partitioning
Previous:From: Andres FreundDate: 2015-08-18 17:46:44
Subject: Re: allowing wal_level change at run time

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group