> ~ 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
