From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
cc: Lukas Fittl <lukas@fittl.com>,
        Jacob Champion <jacob.champion@enterprisedb.com>,
        Dian Fay <di@nmfay.com>, Matheus Alcantara <matheusssilv97@gmail.com>,
        Jakub Wartak <jakub.wartak@enterprisedb.com>,
        PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: pg_plan_advice
In-reply-to: <CA+TgmoaZMOikxK=LqS+Jn+835h9S139JLGk-3LyETVXw5W5j=w@mail.gmail.com>
References: <CA+TgmoZ-Jh1T6QyWoCODMVQdhTUPYkaZjWztzP1En4=ZHoKPzw@mail.gmail.com> <CAKZiRmxtJAFG7e1+Vs9B8ngON=AOzJbuws+1ZeH4LsbJh5AzoQ@mail.gmail.com> <CA+TgmoY9Ne_Sh10u6LSPc3wvOQPLp3kF9nBp3nqJEG2JGF2QiA@mail.gmail.com> <CA+Tgmoa57S6mP=aTOXH2-gDAL4TMO1WbGgrHSg0s6J4zUH=04g@mail.gmail.com> <DEB1SAGVDX7S.JMV96X4R0RCS@gmail.com> <CA+Tgmoaf__2B0BUL+vrg28P+3buX=Ti-kybqkHiLTtFrrCfzuA@mail.gmail.com> <CA+TgmoYpcLNOuypOTdgCSLW7FuA=t6BtB3meTARHX2-Dj_81xQ@mail.gmail.com> <DEFNP3WX7BLX.1X7DS1P9X6JIF@nmfay.com> <CA+TgmoZjv9OyFu1Gkt78w0vWEti8S33w8trYHmErf-GMmGSi=w@mail.gmail.com> <DELPC4B56Y5A.3OBZ3WCH3T4VX@nmfay.com> <CA+TgmoaOSBQD9Ux4eG40w723ZN=c0J7p-+oX4+J8urUeyLMo5w@mail.gmail.com> <CAOYmi+=g+MMoOpWkk2weXWKJcKH0eKey8gKHHdH0dF4Tiawrhw@mail.gmail.com> <CA+TgmobwaT=PXPDDrgDup+jA8KHBbkxigtziD-zNzAKKkQYVgQ@mail.gmail.com> <CAOYmi+mOmEW=amDRQMfw6-Fb3ZmDEQFaJzwk8Bc8W8DzaP85XQ@mail.gmail.com> <CA+TgmoaX2AMW4cdFM3OngBJxmxpkdmzF33R7-CWhvRLfucbFMg@mail.gmail.com> <CAOYmi+njnRGcomnxTY6vsEW3wWigc0r!
 uB0EyWFpb+PVVE8sWpw@mail.gmail.com> <CAOYmi+k4AyWCQHK=XVF99KVDuFkqxcADao61OWGLxu0nRYMONQ@mail.gmail.com> <CA+TgmoZ0x3ym_oueXRWzbM_=6ucKoPZVGj3rRMLBDC_FnetXDw@mail.gmail.com> <CAP53Pkycc=7N2bLzVT3x+qE1JamvRZWev5tFjdLJ1+-AV3Di+Q@mail.gmail.com> <CA+TgmoaKhuD91RnazbRyGkmP7--JdNq8oNDC3UcgTZSWbMxC7w@mail.gmail.com> <CAP53Pkw5-wMEeDJXFmqo_RTyL_spzCXb7HHKrbSnQqokVoZcNQ@mail.gmail.com> <CA+Tgmob-69bzbdi3U_QtebqAf6u1y8js=5=oNK639csVe1VbhA@mail.gmail.com> <CA+TgmoaZMOikxK=LqS+Jn+835h9S139JLGk-3LyETVXw5W5j=w@mail.gmail.com>
Comments: In-reply-to Robert Haas <robertmhaas@gmail.com>
	message dated "Wed, 28 Jan 2026 12:13:39 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1136160.1769654478.1@sss.pgh.pa.us>
Date: Wed, 28 Jan 2026 21:41:18 -0500
Message-ID: <1136161.1769654478@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1136161.1769654478%40sss.pgh.pa.us>
Precedence: bulk

Robert Haas <robertmhaas@gmail.com> writes:
> That rearrangement got done in v11, and I've now committed that patch
> after fixing a few typos that I found. Cautiously, woohoo, but let's
> see if anything breaks.

skink's not happy:

=2162940== VALGRINDERROR-BEGIN
==2162940== Conditional jump or move depends on uninitialised value(s)
==2162940==    at 0x434D366: cost_material (costsize.c:2593)
==2162940==    by 0x436E7E9: materialize_finished_plan (createplan.c:6531)
==2162940==    by 0x4383054: standard_planner (planner.c:533)
==2162940==    by 0x4383541: planner (planner.c:324)
==2162940==    by 0x44C50B4: pg_plan_query (postgres.c:905)
==2162940==    by 0x4237444: standard_ExplainOneQuery (explain.c:354)
==2162940==    by 0x42375DF: ExplainOneQuery (explain.c:310)
==2162940==    by 0x4237A7A: ExplainOneUtility (explain.c:458)
==2162940==    by 0x42375C3: ExplainOneQuery (explain.c:301)
==2162940==    by 0x4237745: ExplainQuery (explain.c:224)
==2162940==    by 0x44CC834: standard_ProcessUtility (utility.c:868)
==2162940==    by 0x44CD09D: ProcessUtility (utility.c:525)
==2162940==  Uninitialised value was created by a stack allocation
==2162940==    at 0x436E76A: materialize_finished_plan (createplan.c:6506)
==2162940== 
==2162940== VALGRINDERROR-END

			regards, tom lane