> ~ 10% slowdown on trivial queries will get noticed.
Agreed.
> I just thought of a possible compromise though: maybe we could invent an
> intermediate constraint_exclusion setting that makes the checks only for
> inheritance-child tables. This would avoid the overhead for simple
> queries and still get the benefit for most of the cases where it's
> actually useful. I'm not sure how hard this'd be to shoehorn into the
> planner, but if it's doable it might satisfy both camps.
+1
...Robert