Re: Optimization issue of branching UNION ALL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Optimization issue of branching UNION ALL
Date
Msg-id 1961091.1671725136@sss.pgh.pa.us
Whole thread Raw
In response to Re: Optimization issue of branching UNION ALL  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
List pgsql-hackers
Andrey Lepikhov <a.lepikhov@postgrespro.ru> writes:
> Thanks, I have written the letter because of some doubts too. But only 
> one weak point I could imagine - if someday sql standard will be changed.

Yeah, if they ever decide that LATERAL should be allowed to reference a
previous sub-query of UNION ALL, that'd probably break this.  But it'd
break a lot of other code too, so I'm not going to worry about it.

I pushed the main fix to HEAD only, and the recursion checks to
all branches.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Ranier Vilela
Date:
Subject: ARRNELEMS Out-of-bounds possible errors
Next
From: Dmitry Dolgov
Date:
Subject: Re: Schema variables - new implementation for Postgres 15 (typo)