Re: Controlling join order with parenthesis - Mailing list pgsql-sql

From Tom Lane
Subject Re: Controlling join order with parenthesis
Date
Msg-id 27781.1284040185@sss.pgh.pa.us
Whole thread Raw
In response to Controlling join order with parenthesis  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-sql
"Marc Mamin" <M.Mamin@intershop.de> writes:
> According to the documentation, I thought it was possible to force given
> join orders with parenthesis.

You can do that if you dial down join_collapse_limit.  Bear in mind that
leaves you *solely* responsible for picking an intelligent join order.
I wouldn't recommend it as a production setting.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Marc Mamin"
Date:
Subject: Controlling join order with parenthesis
Next
From: Greg Caulton
Date:
Subject: sql disaster - subquery error but delete continues