Re: Adding support for Default partition in partitioning

From: Jeevan Ladhe <jeevan(dot)ladhe(at)enterprisedb(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, Beena Emerson <memissemerson(at)gmail(dot)com>, Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, Rahila Syed <rahilasyed90(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Adding support for Default partition in partitioning
Date: 2017-08-31 12:53:22
Message-ID: CAOgcT0ONgwajdtkoq+AuYkdTPY9cLWWLjxt_k4SXue3eieAr+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I have merged the default partition for range[1] patches in attached V26
series of patches.

Here are how the patches now look like:

0001:
This patch refactors RelationBuildPartitionDesc(), basically this is patch
0001 of default range partition[1].

0002:
This patch teaches the partitioning code to handle the NIL returned by
get_qual_for_list().
This is needed because a default partition will not have any constraints in
case
it is the only partition of its parent.

0003:
Support for default partition with the restriction of preventing addition
of any
new partition after default partition. This patch now has support for both
default partition for list and range.

0004:
Extend default partitioning support to allow addition of new partitions
after
default partition is created/attached. This patch is a merge of patches
0005 and 0006 in V24 series to simplify the review process. The
commit message has more details regarding what all is included.

0005:
This patch introduces code to check if the scanning of default partition
child
can be skipped if it's constraints are proven.

0006:
Documentation.

[1]
https://www.postgresql.org/message-id/CAOgcT0MWj9Ao%3Df7C6ZyFce4obNwa_jSWTETMd_-bRfg51zCXbg%40mail.gmail.com

Regards,
Jeevan Ladhe

Attachment Content-Type Size
default_partition_V26.tar application/x-tar 140.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2017-08-31 13:44:13 Re: generated columns
Previous Message Thomas Munro 2017-08-31 12:53:18 Re: Parallel Hash take II