Re: surprisingly expensive join planning query
От | Tom Lane |
---|---|
Тема | Re: surprisingly expensive join planning query |
Дата | |
Msg-id | 3228.1575227835@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: surprisingly expensive join planning query (Tomas Vondra <tomas.vondra@2ndquadrant.com>) |
Ответы |
Re: surprisingly expensive join planning query
|
Список | pgsql-hackers |
Tomas Vondra <tomas.vondra@2ndquadrant.com> writes: > On Sun, Dec 01, 2019 at 01:27:04PM -0500, Tom Lane wrote: >> Alternatively, it'd be possible to get rid of the separate List >> altogether, and just add the rinfo's to "mergeclauses" immediately. >> The functionality of the separate list could be replaced by a >> bool variable remembering whether we found any matches in this >> pass through the loop. I think the code would be a little less >> clear that way, but this report makes it clear that it's a >> performance bottleneck, so maybe we should just change it. > Yes, that might be an option. And it works even on 9.5 for me (per the > attached patch). I don't think it's much less clear compared to just > doing an explicit free at the end. LGTM. regards, tom lane
В списке pgsql-hackers по дате отправления: