EmmyMiao87 commented on a change in pull request #8695: URL: https://github.com/apache/incubator-doris/pull/8695#discussion_r836226913
########## File path: fe/fe-core/src/main/java/org/apache/doris/planner/JoinCostEvaluation.java ########## @@ -147,7 +149,7 @@ public long constructHashTableSpace() { Math.pow(1.5, (int) ((Math.log((double) rhsTreeCardinality/4096) / Math.log(1.5)) + 1)) * 4096; double nodeOverheadSpace = nodeArrayLen * 16; double nodeTuplePointerSpace = nodeArrayLen * rhsTreeTupleIdNum * 8; - return Math.round((bucketPointerSpace + (double) rhsTreeCardinality * rhsTreeAvgRowSize + return Math.round((bucketPointerSpace + (double) rhsTreeCardinality * rhsTreeAvgRowSize * COMPRESSION_RATIO Review comment: Currently the average size of each row is indeed calculated using the compressed data. But simply multiplying by a fixed compression ratio is certainly inaccurate. Or can you use the actual test data to cite the test data that the compression ratio here will be more closely related to the actual memory consumption after multiplying by 5? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org