Home > mailing lists

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

From	Jeevan Ladhe
Subject	Re: [HACKERS] Adding support for Default partition in partitioning
Date	September 6, 2017 14:55:18
Msg-id	CAOgcT0OM_Px6BXp1uDhhArw0bm-q4zCD5YwhDywR3K9ziBNL6A@mail.gmail.com Whole thread Raw
In response to	Re: [HACKERS] Adding support for Default partition in partitioning (Jeevan Ladhe <jeevan.ladhe@enterprisedb.com>)
Responses	Re: [HACKERS] Adding support for Default partition in partitioning
List	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.

Regards,

Jeevan Ladhe

From: Sokolov Yura
Date: 06 September 2017, 14:54:55
Subject: Re: [HACKERS] Fix performance of generic atomics

From: Tom Lane
Date: 06 September 2017, 15:14:41
Subject: Re: [HACKERS] 【ECPG】strncpy function does not set the end character '\0'