On Wed, 2009-01-07 at 12:26 -0500, Robert Haas wrote:
> > ~ 10% slowdown on trivial queries will get noticed.
> > 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.
I can buy into this.
Joshua D. Drake
>
> +1
>
> ...Robert
>
--
PostgreSQL Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL
Company,serving since 1997