User guide

ValueJSON PropertyConsole Field
The
amount
of
memory
to
al-
loc-
ate
to
the
queue.
The
total
amount
of
memory
across
all
queues
must
equal
100
per-
cent,
so
if
you
set
this
prop-
erty
for
one
queue,
you
must
set
the
oth-
er
queues
ac-
cord-
ingly.
memory_percent_to_use% Memory
For more information about each of these properties, go to Defining Query Queues in the Amazon Redshift
Database Developer Guide.
When you create a parameter group, the default WLM configuration is one queue that can run up to five
queries concurrently.You can add additional queues and configure WLM properties in each of them if
you want more control over query processing. Each queue that you add has the same default WLM
configuration until you configure its properties.
The last queue specified in the WLM configuration is the default queue. Unless a query is routed to another
queue based on criteria in the WLM configuration, it is processed by the default queue.You cannot specify
API Version 2012-12-01
68
Amazon Redshift Management Guide
Configuring Workload Management