Horton

Re: selecting from partitions and constraint exclusion

Thibaut Madelaine <thibaut.madelaine@dalibo.com>

View thread View on postgr.es
From: Thibaut <thibaut.madelaine@dalibo.com>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, David Rowley <david.rowley@2ndquadrant.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>, 'Yuzuko Hosoya' <hosoya.yuzuko@lab.ntt.co.jp>
Date: 2019-04-05T16:12:12Z
Lists: pgsql-hackers 
Le 25/03/2019 à 01:31, Amit Langote a écrit :
> On 2019/03/22 17:17, Amit Langote wrote:
>> I'll add this to July fest to avoid forgetting about this.
> I'd forgotten to do this, but done today. :)
>
> Thanks,
> Amit

Hello Amit,

Just a quick information that your last patch does not apply on head:

$ git apply
~/Téléchargements/v2-0001-Fix-planner-to-load-partition-constraint-in-some-.patch
error: patch failed: src/test/regress/expected/partition_prune.out:3637
error: src/test/regress/expected/partition_prune.out: patch does not apply

Manually applying it on top of Hosoya's last 2 patches, It corrects the
different cases we found so far.
I will keep on testing next week.

Cordialement,

Thibaut

Commits

  1. Clean up handling of constraint_exclusion and enable_partition_pruning.