diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/join_hash.out
--- /Users/admin/pgsql/src/test/regress/expected/join_hash.out	2024-04-08 08:30:45
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/join_hash.out	2024-04-08 08:35:07
@@ -1138,18 +1138,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,