PM join can eat too much RAM in PrimProc

With a 500GB DBT3 on a single server setup 64GB RAM server the following query causes PrimProc to consume all RAM and swap with the PM joiner until the kernel kills it:

select l_shipmode, l_comment, o_clerk from lineitem join orders on l_orderkey = o_orderkey where o_orderdate = '1997-05-06';