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: (view raw, whole thread or download thread mbox)
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


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