Re: Declarative partitioning - Mailing list pgsql-hackers

From Marc Mamin
Subject Re: Declarative partitioning
Date
Msg-id B6F6FD62F2624C4C9916AC0175D56D8828C1FA5A@jenmbs01.ad.intershop.net
Whole thread Raw
In response to Declarative partitioning  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: Declarative partitioning  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List 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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: allowing wal_level change at run time
Next
From: Corey Huinker
Date:
Subject: Re: Declarative partitioning