| From: | Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com> |
|---|---|
| To: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> |
| Subject: | Test patch for partitionwise join with partitioned tables containing default partition |
| Date: | 2018-06-06 05:56:23 |
| Message-ID: | CAKcux6ky5YeZAY74qSh-ayPZZEQchz092g71iXXbC0+E3xoscA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
As of now partition_join.sql is not having test cases covering cases
where partition table have default partition, attaching a small test
case patch to cover those.
Here is a link of previous discussion :
https://www.postgresql.org/message-id/CAKcux6%3DLO-
XK9G0yLe634%2B0SP2UOn5ksVnmF-OntTBOEEaUGTg%40mail.gmail.com
As found by Thomas, The regression test currently fails with v4 patch
because a
redundant Result node has been removed from a query plan. here is the
updated
v5 patch fixing this.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
| Attachment | Content-Type | Size |
|---|---|---|
| partitionwise_join_with_default_partitions_v5.patch | text/x-patch | 6.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2018-06-06 05:57:42 | Re: Performance regression with PostgreSQL 11 and partitioning |
| Previous Message | Chris Travers | 2018-06-06 05:27:40 | Re: Code of Conduct plan |