Nestloop join should materialize inner as much as possible about gporca HOT 1 CLOSED

vraghavan=# explain select * from foo, (select * from bar, pt where bar.b = pt.b) a;
                                                     QUERY PLAN
--------------------------------------------------------------------------------------------------------------------
 Gather Motion 3:1  (slice3; segments: 3)  (cost=0.00..1356691662.88 rows=1 width=24)
   ->  Nested Loop  (cost=0.00..1356691662.88 rows=1 width=24)
         Join Filter: bar.b = pt.b
         ->  Nested Loop  (cost=0.00..1324032.20 rows=1 width=16)
               Join Filter: true
               ->  Broadcast Motion 3:3  (slice2; segments: 3)  (cost=0.00..431.00 rows=1 width=8)
                     ->  Table Scan on foo  (cost=0.00..431.00 rows=1 width=8)
               ->  Table Scan on bar  (cost=0.00..431.00 rows=1 width=8)
         ->  Materialize  (cost=0.00..431.00 rows=1 width=8)
               ->  Broadcast Motion 3:3  (slice1; segments: 3)  (cost=0.00..431.00 rows=1 width=8)
                     ->  Sequence  (cost=0.00..431.00 rows=1 width=8)
                           ->  Partition Selector for pt (dynamic scan id: 1)  (cost=10.00..100.00 rows=34 width=4)
                                 Partitions selected: 2 (out of 2)
                           ->  Dynamic Table Scan on pt (dynamic scan id: 1)  (cost=0.00..431.00 rows=1 width=8)
 Settings:  optimizer_join_order=query
 Optimizer status: PQO version 3.21.0
(16 rows)