Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: 【咨询类】tiflash join物理算子支持外存功能吗?
If the physical machine’s memory configuration is relatively low and running multi-table joins causes insufficient memory, how should it be handled?
Can the SQL be further optimized?
If it cannot be further optimized, you can consider using disk storage by setting the following parameters:
oom-use-tmp-storage
tmp-storage-path
tmp-storage-quota
Currently, there is no documentation stating that external storage is supported. If SQL optimization has been done to the utmost, it is recommended to add a physical machine.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.