Scott Ribe <scott_ribe(at)elevated-dev(dot)com> writes:
>> On Nov 28, 2022, at 7:44 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Why do you say this is a regression? From what I know of the partition
>> pruning logic (admittedly not a whole lot), I don't think we'd have
>> ever pruned on the basis of such a constraint.
> Because performance of the query tanked.
Compared to what? If you said something like "it worked as I expected
in Postgres x.y", that would be something to go on.
regards, tom lane