> 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. If it's not a change in table pruning, then it's a change in whether/how/which indexes are used. I guess I'll have to dig into it more and get back to the list--probably tomorrow.
Meantime, thanks for the clue to help guide me here.