Re: [HACKERS] Disable cross products in postgres - Mailing list pgsql-hackers

From Gourav Kumar
Subject Re: [HACKERS] Disable cross products in postgres
Date
Msg-id CAPzqDmgAqcfEaCSzXYm5D2-WLjK2O3Shqmh6mDW3UtNfCW+vgg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Disable cross products in postgres  (Andres Freund <andres@anarazel.de>)
List 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@anarazel.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

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] Disable cross products in postgres
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Aggregate transition state merging vs. hypothetical set functions