Re: Self contradictory examining on rel's baserestrictinfo

On Mon, Nov 25, 2024 at 4:39 PM Tom Lane <tgl@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