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 <gourav1...@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 < > fabriziome...@gmail.com> wrote: > >> >> On Fri, Oct 13, 2017 at 5:08 PM, Robert Haas <robertmh...@gmail.com> >> wrote: >> > >> > On Fri, Oct 13, 2017 at 4:06 PM, Gourav Kumar <gourav1...@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
