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-09-06 11:55:18
Message-ID: CAOgcT0OM_Px6BXp1uDhhArw0bm-q4zCD5YwhDywR3K9ziBNL6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Attached is the rebased set of patches.
Robert has committed[1] patch 0001 in V26 series, hence the patch numbering
in V27 is now decreased by 1 for each patch as compared to V26.

This set of patches also addresses comments[2] given by Ashutosh.

Here is the description of the patches:

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 patch has support for default
partition for both list and range.
Addition to V26 patch 0003 following are the additional changes here:;
1. Some changes in range default partition comments given by Beena offline.
2. I have shifted definition of macro partition_bound_has_default to next
patch
as it wasn't used in this patch at all.

0003:
Extend default partitioning support to allow addition of new partitions
after
default partition is created/attached.

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%2BTgmoa5oKefW27VXD%3DmLRo0_SbbFj%3DScybc-MZist7X3EkNmA%40mail.gmail.com

[2]
https://www.postgresql.org/message-id/CAFjFpReO7VQtES6k%2BzNXF_cttNZU%2BcZ8U4HwN%2B%2BWVSTuFG6PyQ%40mail.gmail.com

Regards,
Jeevan Ladhe

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-09-06 12:14:41 Re: 【ECPG】strncpy function does not set the end character '\0'
Previous Message Sokolov Yura 2017-09-06 11:54:55 Re: Fix performance of generic atomics