Re: [GENERAL] Materializing the relation

>>QUERY PLAN >> >> Nested Loop (cost=1.03..2.34 rows=3 width=24) >>Join Filter: (tb1.c1 = tb2.c1) >>-> Seq Scan on tb2 (cost=0.00..1.04 rows=4 width=12) >>-> Materialize (cost=1.03..1.06

Re: [GENERAL] Materializing the relation

From /src/include/utils/tuplestore.h "The materialize shields the sort from the need to do mark/restore and thereby allows it to perform its final merge pass on-the-fly; while the materialize itself is normally cheap since it won't spill to disk unless the number of tuples with equal key values