Re: [HACKERS] Adding support for Default partition in partitioning - Mailing list pgsql-hackers

Hi,

On Tue, Aug 15, 2017 at 7:20 PM, Robert Haas <robertmhaas@gmail.com> wrote:

On Wed, Jul 26, 2017 at 8:14 AM, Jeevan Ladhe
<jeevan.ladhe@enterprisedb.com> wrote:
> I have rebased the patches on the latest commit.

This needs another rebase.

I have rebased the patch and addressed your and Ashutosh comments on last set of patches.

The current set of patches contains 6 patches as below:

0001:

Refactoring existing ATExecAttachPartition  code so that it can be used for

default partitioning as well

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 is a merge of 0003 and 0004 in

V24 series.

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.

After patch 0001 in above series got committed[1], I have rebased the patches.

The attached set of patches now looks like below:

0001:

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.

0002:

Support for default partition with the restriction of preventing addition of any

new partition after default partition. This is a merge of 0003 and 0004 in

V24 series.

0003:

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.

0004:

This patch introduces code to check if the scanning of default partition child

can be skipped if it's constraints are proven.

0005:

Documentation.

[1] https://www.postgresql.org/message-id/CA%2BTgmoYp-QePjTGEC6W%2BRfuh%3DTMZ4Hj8t2fX2o8cbhto6zS9DA%40mail.gmail.com

Regards,