diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join_hash.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out	2025-06-27 08:32:15.915649236 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join_hash.out	2025-06-27 08:39:40.648831009 +0000
@@ -1137,18 +1137,21 @@
 int8_tbl i8,
 lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
          on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
-                        QUERY PLAN                         
------------------------------------------------------------
+                           QUERY PLAN                            
+-----------------------------------------------------------------
  Nested Loop
    ->  Seq Scan on int8_tbl i8
-   ->  Sort
-         Sort Key: t1.fivethous, i4.f1
-         ->  Hash Join
-               Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
-               ->  Seq Scan on tenk1 t1
-               ->  Hash
-                     ->  Seq Scan on int4_tbl i4
-(9 rows)
+   ->  Memoize
+         Cache Key: i8.q2
+         Cache Mode: binary
+         ->  Sort
+               Sort Key: t1.fivethous, i4.f1
+               ->  Hash Join
+                     Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
+                     ->  Seq Scan on tenk1 t1
+                     ->  Hash
+                           ->  Seq Scan on int4_tbl i4
+(12 rows)
 
 select i8.q2, ss.* from
 int8_tbl i8,