[Consultation] Does the TiFlash join physical operator support external storage functionality?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 【咨询类】tiflash join物理算子支持外存功能吗?

| username: TiDBer_abThS2LT

If the physical machine’s memory configuration is relatively low and running multi-table joins causes insufficient memory, how should it be handled?

| username: Edwin | Original post link

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

| username: Running | Original post link

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.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.