2 個答案
- 最新
- 最多得票
- 最多評論
0
Thanks, yes, we rewrote our query and worked around this... thanks for your information.
已回答 2 年前
0
How is your WLM set up? If it is Manual WLM set up, you need to see how much memory allocation is given for queue in which your query will be running If you have set up a higher concurrency per WLM queue each slot gets less memory. You can allocate higher memory for specific query by Allocating a higher query_slot_count to your query: For example set wlm_query_slot_count to 3; to allocate 3 query slots
Alternatively you can simplify your query with additional interim processing tables and select columns which are required.
You can also refer Auto WLM- https://docs.aws.amazon.com/redshift/latest/dg/automatic-wlm.html where memory management is dynamic
相關內容
- 已提問 7 個月前
- 已提問 10 個月前
- AWS 官方已更新 2 年前
- AWS 官方已更新 3 年前
- AWS 官方已更新 1 年前