Switching WLM mode
You can enable automatic or manual WLM using the Amazon Redshift console:
Choose Switch WLM mode.
To set it to automatic WLM, choose Auto WLM. With this choice, up to eight queues are used to manage queries, and the Memory and Concurrency on main fields are both set to Auto. Additionally, the default priority of queries is set to Normal.
-
To enable manual configuration using the Amazon Redshift console, switching to Manual WLM. With this choice, you specify the queues used to manage queries, and the Memory and Concurrency on main field values. With a manual configuration, you can configure up to eight query queues and set the number of queries that can run in each of those queues concurrently.