> On Thu, Dec 23, 2004 at 10:01:33AM -0500, Tom Lane wrote:
>> Right. This amounts to assuming that the join conditions and the
>> restriction conditions are independent, which of course is bogus,
>> but we really don't have enough information to do better.
> Doesn't JOINSEL have access to RESTRICTSEL output for REL1 and REL2 ?
You could probably compare the fields of the RelOptInfo structures,
but what are you going to do with it? AFAICS you *should not* make
the join selectivity depend on that.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2004-12-23 15:35:52|
|Subject: Re: Connection without database name |
|Previous:||From: strk||Date: 2004-12-23 15:10:03|
|Subject: Re: join selectivity|