| 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: | Whole Thread | Raw Message | 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 |