RE: Problem with default partition pruning

Yuzuko Hosoya <hosoya.yuzuko@lab.ntt.co.jp>

From: "Yuzuko Hosoya" <hosoya.yuzuko@lab.ntt.co.jp>

To: "'Amit Langote'" <Langote_Amit_f8@lab.ntt.co.jp>, "'Thibaut'" <thibaut.madelaine@dalibo.com>, "'Imai, Yoshikazu'" <imai.yoshikazu@jp.fujitsu.com>

Cc: "'PostgreSQL Hackers'" <pgsql-hackers@lists.postgresql.org>

Date: 2019-04-02T05:02:08Z

Lists: pgsql-hackers

Attachments

ignore_contradictory_where_clauses_at_partprune_step.patch (application/octet-stream) patch
v3_default_partition_pruning.patch (application/octet-stream) patch v3

Hi,

> Maybe we should have two patches as we seem to be improving two things:
> 
> 1. Patch to fix problems with default partition pruning originally reported by Hosoya-san
> 
> 2. Patch to determine if a given clause contradicts a sub-partitioned table's partition constraint,
> fixing problems unearthed by Thibaut's tests

I attached the latest patches according to Amit comment.
v3_default_partition_pruning.patch fixes default partition pruning problems
and ignore_contradictory_where_clauses_at_partprune_step.patch fixes
sub-partition problems Thibaut tested.

Best regards,
Yuzuko Hosoya

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