Re: Do we still need constraint_exclusion? - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Do we still need constraint_exclusion?
Date
Msg-id 1231349724.12947.42.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Re: Do we still need constraint_exclusion?  ("Robert Haas" <robertmhaas@gmail.com>)
List pgsql-hackers
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
 



pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: Do we still need constraint_exclusion?
Next
From: Tom Lane
Date:
Subject: Re: Do we still need constraint_exclusion?