Postgres Pro
Downloads
Home   >   mailing lists

Re: ANSI JOINS versus , like JOINS - Mailing list pgsql-sql

From Tom Lane
Subject Re: ANSI JOINS versus , like JOINS
Date
Msg-id 11580.1466430132@sss.pgh.pa.us
Whole thread Raw
In response to ANSI JOINS versus , like JOINS  (Herwig Goemans <herwig.goemans@gmail.com>)
Responses Re: ANSI JOINS versus , like JOINS
List pgsql-sql
Tree view 
Herwig Goemans <herwig.goemans@gmail.com> writes:
> Is there anyone who can help so that the mixed query has the same or
> equivalent execution plan (performance) as the ansi query ?

I think you need to raise join_collapse_limit and/or from_collapse_limit.
        regards, tom lane

pgsql-sql by date:

Previous
From: Herwig Goemans
Date:
Subject: ANSI JOINS versus , like JOINS
Next
From: Herwig Goemans
Date:
Subject: Re: ANSI JOINS versus , like JOINS