diff -U3 /home/postgres/postgres/src/test/regress/expected/join.out /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/join.out --- /home/postgres/postgres/src/test/regress/expected/join.out Mon Mar 2 09:12:07 2026 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/join.out Mon Mar 2 09:16:06 2026 @@ -10079,16 +10079,16 @@ select * from hjbucket h1 join hjbucket h2 on h1.val = h2.val where h1.filt = 5; - QUERY PLAN ----------------------------------------------------------- + QUERY PLAN +---------------------------------------------------- Hash Join - Hash Cond: (h2.val = h1.val) - -> Seq Scan on hjbucket h2 + Hash Cond: (h1.val = h2.val) + -> Bitmap Heap Scan on hjbucket h1 + Recheck Cond: (filt = 5) + -> Bitmap Index Scan on hjbucket_filt_idx + Index Cond: (filt = 5) -> Hash - -> Bitmap Heap Scan on hjbucket h1 - Recheck Cond: (filt = 5) - -> Bitmap Index Scan on hjbucket_filt_idx - Index Cond: (filt = 5) + -> Seq Scan on hjbucket h2 (8 rows) reset work_mem;