Re: join selectivity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: join selectivity
Дата
Msg-id 28399.1103814783@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: join selectivity  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
Ответы Re: join selectivity
Список pgsql-hackers
strk@refractions.net writes:
> 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Regression (semi)fix for netbsd-mac68k
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Connection without database name