Re: Constraint Exclusion + Joins? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Constraint Exclusion + Joins?
Date
Msg-id 25262.1146548826@sss.pgh.pa.us
Whole thread Raw
In response to Re: Constraint Exclusion + Joins?  ("Brandon Black" <blblack@gmail.com>)
List pgsql-hackers
"Brandon Black" <blblack@gmail.com> writes:
> Is this sort of dynamic constraint exclusion on the radar?

What sort of fantasy have you got in mind?

It doesn't seem likely to me that testing constraints explicitly against
each row from the other table would be a win compared to letting the
indexes do it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Brandon Black"
Date:
Subject: Re: Constraint Exclusion + Joins?
Next
From: "Nikolay Samokhvalov"
Date:
Subject: Re: Google SoC--Idea Request