Re: Constraint Exclusion + Joins?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Brandon Black" <blblack(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Constraint Exclusion + Joins?
Date: 2006-05-02 05:47:06
Message-ID: 25262.1146548826@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Brandon Black" <blblack(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nikolay Samokhvalov 2006-05-02 08:34:43 Re: Google SoC--Idea Request
Previous Message Brandon Black 2006-05-02 05:27:10 Re: Constraint Exclusion + Joins?