Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> writes: >> 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. 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
