[Question]tpch测试文档优化

ApsaraDB / PolarDB-for-PostgreSQL

A cloud-native database based on PostgreSQL developed by Alibaba Cloud.

Apache License 2.0

2.86k stars 457 forks source link

Open digoal opened 7 months ago

digoal commented 7 months ago

Describe the problem

使用 ePQ 执行 Q17 和 Q18 时可能会出现 OOM。需要设置以下参数防止用尽内存： SET polar_px_optimizer_enable_hashagg = 0;

需要增加说明:
如何解决oom, 例如什么版本将支持on disk hashagg?
关闭后性能是否会变差?
还有没有其他参数可控制hashagg内存使用? 例如work_mem?

polardb-bot[bot] commented 7 months ago

Hi @digoal ~ Thanks for opening this issue! 🎉

Please make sure you have provided enough information for subsequent discussion.

We will get back to you as soon as possible. ❤️