Switching WLM mode - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Switching WLM mode

You can enable automatic or manual WLM using the Amazon Redshift console:

  1. Choose Switch WLM mode.

  2. 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.

  3. 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.