Re: Problem with default partition pruning

Shawn Wang <shawn.wang@highgo.ca>

From: Shawn Wang <shawn.wang@highgo.ca>

To: pgsql-hackers@lists.postgresql.org

Cc: Yuzuko Hosoya <yuzukohosoya@gmail.com>

Date: 2019-06-17T03:28:41Z

Lists: pgsql-hackers

The following review has been posted through the commitfest application:
make installcheck-world:  tested, failed
Implements feature:       tested, passed
Spec compliant:           not tested
Documentation:            not tested

Hi Hosoya-san,
I tested different types of key values, and multi-level partitioned tables, and found no problems.
Only the SQL in the file of src/test/regress/results/partition_prune.out has a space that caused the regression test to fail.

The new status of this patch is: Waiting on Author

Commits

Don't constraint-exclude partitioned tables as much
- 815ef2f568c7 13.0 landed
Apply constraint exclusion more generally in partitioning
- 4e85642d935e 13.0 landed
Improve pruning of a default partition
- e3967a16d3a0 11.5 landed
- 86544071484a 12.0 landed
- 489247b0e615 13.0 landed
Doc: Fix event trigger firing table
- 44460d7017cd 13.0 cited
Remove obsolete nbtree insertion comment.
- 489e431ba56b 12.0 cited