gporca icon indicating copy to clipboard operation
gporca copied to clipboard

Published 20 hours ago • verified publisher icon greenplum-db

memory threshold for hash join spilling should be dynamic

Open hsyuan opened this issue 6 years ago • 0 comments

In function CCostModelGPDB::CostHashJoin, it uses if (dRowsInner * dWidthInner <= dHJSpillingMemThreshold) to determine whether the hash table can fit into memory or not, but it looks like the threshold CCostModelParamsGPDB::DHJSpillingMemThresholdVal is fixed to 50MB. Should it be dynamic and accept value from GPDB?

hsyuan avatar Mar 05 '18 06:03 hsyuan