2 Risposte
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
0
Thanks, yes, we rewrote our query and worked around this... thanks for your information.
con risposta 2 anni fa
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
Contenuto pertinente
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata 9 mesi fa