JoshRosen commented on issue #27246: [SPARK-30536][CORE][SQL] Sort-merge join operator spilling performance improvements URL: https://github.com/apache/spark/pull/27246#issuecomment-577491122 Regarding decreasing the initial memory read buffer size in `UnsafeSorterSpillReader` from 1MB to 1KB: Intuitively this also make sense to me: AFAIK this buffer only needs to be large enough to hold a single record and records >= 1MB are probably _relatively_ rare. I'm not sure what the optimal threshold here is, though, since I don't really have data on median record sizes for representative real-world workloads.
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
