Re: ANSI JOINS versus , like JOINS
| От | Herwig Goemans |
|---|---|
| Тема | Re: ANSI JOINS versus , like JOINS |
| Дата | |
| Msg-id | CAKaDz_H8JrE6ojYkrvRARfJ1nt+dy4aNpixNZagTMenxshw0-w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: ANSI JOINS versus , like JOINS (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-sql |
<p dir="ltr">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.<br /> Thanks<br/> Herwig <div class="gmail_quote">Op 20 jun. 2016 3:42 p.m. schreef "Tom Lane" <<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>>:<brtype="attribution" /><blockquote class="gmail_quote" style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Herwig Goemans <<a href="mailto:herwig.goemans@gmail.com">herwig.goemans@gmail.com</a>>writes:<br /> > Is there anyone who can help sothat the mixed query has the same or<br /> > equivalent execution plan (performance) as the ansi query ?<br /><br />I think you need to raise join_collapse_limit and/or from_collapse_limit.<br /><br /> regards,tom lane<br /></blockquote></div>
В списке pgsql-sql по дате отправления: