Re: [HACKERS] Disable cross products in postgres

Поиск
Список
Период
Сортировка
От Gourav Kumar
Тема Re: [HACKERS] Disable cross products in postgres
Дата
Msg-id CAPzqDmjm+j1keZHOjsQv4GieNw8VrWogkKbpiB8SH6=pJYGHmQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Disable cross products in postgres  (Gourav Kumar <gourav1905@gmail.com>)
Ответы Re: [HACKERS] Disable cross products in postgres  (Gourav Kumar <gourav1905@gmail.com>)
Список pgsql-hackers
I tried debugging the code, at no point in execution the function  make_rels_by_clauseless_joins was called.  Although optimizer did consider some of the  joins which are cross products.

On 14 October 2017 at 01:57, Gourav Kumar <gourav1905@gmail.com> wrote:
Can I use something like joininfo, which will store the join predicates and I can check if there is no join predicate among the two relations don't consider them.

On 14 October 2017 at 01:48, Fabrízio de Royes Mello <fabriziomello@gmail.com> wrote:

On Fri, Oct 13, 2017 at 5:08 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>
> On Fri, Oct 13, 2017 at 4:06 PM, Gourav Kumar <gourav1905@gmail.com> wrote:
> > Can you guide me where to look for it?
>
> Search for make_rels_by_clauseless_joins.
>

I wonder if it's possible implement it as an extension using some hook

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello



--
Thanks,
Gourav Kumar
Computer Science and Automation
Indian Institute of Science



--
Thanks,
Gourav Kumar
Computer Science and Automation
Indian Institute of Science

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: [HACKERS] Extended statistics is not working on Vars hidden undera RelabelType
Следующее
От: Gourav Kumar
Дата:
Сообщение: Re: [HACKERS] Disable cross products in postgres