Re: Disable cross products in postgres

From: Gourav Kumar <gourav1905(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: fabriziomello(at)gmail(dot)com, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Disable cross products in postgres
Date: 2017-10-13 22:30:15
Message-ID: CAPzqDmgAqcfEaCSzXYm5D2-WLjK2O3Shqmh6mDW3UtNfCW+vgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I want to get the join graph of a given query. Which has node for each
relation and an edge between two nodes if they have a join predicate among
them.
On 14-Oct-2017 3:58 AM, "Andres Freund" <andres(at)anarazel(dot)de> wrote:

> On 2017-10-14 03:49:57 +0530, Gourav Kumar wrote:
> > But then is there some way to tell Optimizer not to consider transitive
> > joins ?
>
> What are you actually trying to achieve here?
>
> - Andres
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-10-13 23:01:18 Re: Aggregate transition state merging vs. hypothetical set functions
Previous Message Andres Freund 2017-10-13 22:28:00 Re: Disable cross products in postgres