From: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Amit Langote <amitlangote09(at)gmail(dot)com>, Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Declarative partitioning - another take |
Date: | 2016-11-15 10:30:17 |
Message-ID: | 56ec5504-c4d7-534c-8832-696dddfd58d1@lab.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2016/11/11 19:30, Amit Langote wrote:
>
> Attached updated patches.
Here is the latest version of the patches with some fixes along with those
mentioned below (mostly in 0003):
- Fixed the logic to skip the attach partition validation scan such that
it won't skip scanning a list partition *that doesn't accept NULLs* if
the partition key column is not set NOT NULL (it similarly doesn't skip
scanning a range partition if either of the partition key columns is not
set NOT NULL, because a range partition key cannot contain NULLs at all)
- Added some more regression tests for ATTACH PARTITION command
- Some fixes to documentation and source code comments
Thanks,
Amit
Attachment | Content-Type | Size |
---|---|---|
0001-Catalog-and-DDL-for-partitioned-tables-14.patch | text/x-diff | 115.3 KB |
0002-psql-and-pg_dump-support-for-partitioned-tables-14.patch | text/x-diff | 23.9 KB |
0003-Catalog-and-DDL-for-partitions-14.patch | text/x-diff | 208.2 KB |
0004-psql-and-pg_dump-support-for-partitions-14.patch | text/x-diff | 22.1 KB |
0005-Teach-a-few-places-to-use-partition-check-quals-14.patch | text/x-diff | 30.9 KB |
0006-Introduce-a-PartitionTreeNode-data-structure-14.patch | text/x-diff | 8.0 KB |
0007-Tuple-routing-for-partitioned-tables-14.patch | text/x-diff | 43.2 KB |
0008-Update-DDL-Partitioning-chapter-to-reflect-new-devel-14.patch | text/x-diff | 24.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Kyotaro HORIGUCHI | 2016-11-15 11:25:13 | Re: asynchronous execution |
Previous Message | Rushabh Lathia | 2016-11-15 10:04:22 | Re: Push down more UPDATEs/DELETEs in postgres_fdw |