Re: planner issue with constraint exclusion - Mailing list pgsql-hackers

From Tom Lane
Subject Re: planner issue with constraint exclusion
Date
Msg-id 16537.1229389806@sss.pgh.pa.us
Whole thread Raw
In response to Re: planner issue with constraint exclusion  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
> On Mon, 2008-12-15 at 14:28 -0500, Tom Lane wrote:
>> "Joshua D. Drake" <jd@commandprompt.com> writes:
>>> Of the functions the only one that will use constraint_exclusion is the
>>> one that explicitly passes the date value.
>> 
>> Since you haven't shown us the constraints you're talking about, or the
>> resulting plans, it's difficult for anyone to guess what's going on.

> Check constraints:
>     "foo_stats_day_q1_day_check" CHECK (day >= '2007-01-01'::date AND
> day < '2007-04-01'::date)

Well, that certainly looks like constraint exclusion should work with
the EXECUTE case.  What leads you to conclude it doesn't?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Mostly Harmless: Welcoming our C++ friends
Next
From: Emmanuel Cecchet
Date:
Subject: Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1