Re: Declarative partitioning

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Declarative partitioning
Date: 2016-02-17 02:56:27
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 2016/02/15 10:55, Amit Langote wrote:
> required. There is also basic planner support but no support yet to enable
> constraint exclusion on partitions (which will be fulfilled shortly by
> installing equivalent check constraints on partitions).

Just to follow up on this - attached now adds equivalent check constraint
with partition creation. Constraint exclusion should work. No regression
tests yet though.

From now on, instead of attaching multiple files like in the previous
message, I will send a single tar.gz which will contain patches created by


Attachment Content-Type Size
decl-part-20160217-1.tar.gz application/gzip 81.8 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Chapman Flack 2016-02-17 03:17:50 How are CREATE EXTENSION ... VERSION or ALTER EXTENSION ... UPDATE TO ... intended to work?
Previous Message Jim Nasby 2016-02-17 02:43:10 Re: proposal: enhancing slow query log, and autoexplain log about waiting on lock before query exec time