Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: [SQL] ANSI JOINS versus , like JOINS
3 views
Skip to first unread message
Tom Lane
Jun 20, 2016, 9:43:21 AM6/20/16
to
Herwig Goemans <herwig....@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
--
Sent via pgsql-sql mailing list (pgsq...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
> 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
--
Sent via pgsql-sql mailing list (pgsq...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Herwig Goemans
Jun 20, 2016, 11:35:51 AM6/20/16
to
Your help is very much appreciated, I did that already short after I sent the mail and it resolved the issue. However I do not understand why there is a difference in behaviour between ansi join and comma like join.
Thanks
Herwig
Op 20 jun. 2016 3:42 p.m. schreef "Tom Lane" <t...@sss.pgh.pa.us>:
0 new messages