On Mon, Nov 25, 2024 at 4:39 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > BTW, it's also worth pointing out the constraint_exclusion GUC. > If that's turned up to "on" from its default setting of "partition", > it authorizes the planner to spend more effort looking for > contradictory quals. It might be reasonable to gate some of these > checks with that. (I also can't help wondering if any of them are > already implemented but are hidden behind that. I think Robert > must have had constraint_exclusion = on for his examples a > couple messages back.)
I definitely didn't change the value of that setting. It's possible I was running on an older branch, but I don't think it was anything ancient. -- Robert Haas EDB: http://www.enterprisedb.com
