Re: Disable cross products in postgres

From: Gourav Kumar <gourav1905(at)gmail(dot)com>
To: fabriziomello(at)gmail(dot)com
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Disable cross products in postgres
Date: 2017-10-13 20:27:03
Message-ID: CAPzqDmhT58=OoRjBxXCQBFBnDm8O4+YyMf4comGEYNBYECBHYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)gmail(dot)com> wrote:

>
> On Fri, Oct 13, 2017 at 5:08 PM, Robert Haas <robertmhaas(at)gmail(dot)com>
> wrote:
> >
> > On Fri, Oct 13, 2017 at 4:06 PM, Gourav Kumar <gourav1905(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2017-10-13 20:36:11 Re: [PATCH] pageinspect function to decode infomasks
Previous Message Robert Haas 2017-10-13 20:21:53 Re: Parallel safety for extern params