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

From Dimitri Fontaine
Subject Re: Do we still need constraint_exclusion?
Date
Msg-id A76FB8ED-7923-4E89-A308-313CAD3805CF@hi-media.com
Whole thread Raw
In response to Re: Do we still need constraint_exclusion?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Le 7 janv. 09 à 22:21, Simon Riggs <simon@2ndQuadrant.com> a écrit :

>
> On Wed, 2009-01-07 at 12:54 -0500, Tom Lane wrote:
>
>> So, barring objections, I'll go make this happen.
>
> I don't really understand this. Who can set up an inherited table
> structure but can't remember to turn on constraint_exclusion? That is
> the easiest part of the whole process by a long way. Nobody has this
> table design by accident, they've all been told how or read the docs.
>
> I'm not against the change so much as bemused by it.

I think the improvement is not in the usability part but the
performance benefit of avoiding lots of cpu cycles when there's no
gain to hope.

And I like the new option!
--
dim

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Significant oversight in that #include-removal script
Next
From: Simon Riggs
Date:
Subject: Re: Latest version of Hot Standby patch