Re: ANSI JOINS versus , like JOINS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Herwig Goemans <herwig(dot)goemans(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ANSI JOINS versus , like JOINS
Date: 2016-06-20 13:42:12
Message-ID: 11580.1466430132@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Herwig Goemans <herwig(dot)goemans(at)gmail(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Herwig Goemans 2016-06-20 15:35:36 Re: ANSI JOINS versus , like JOINS
Previous Message Herwig Goemans 2016-06-20 10:06:26 ANSI JOINS versus , like JOINS