> On Nov 28, 2022, at 7:44 AM, Tom Lane <tgl@xxxxxxxxxxxxx> 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.