Value
Parameter Name
0
statement_timeout
[{"query_concurrency":5}]
wlm_json_configuration
For more information about these parameters, go to
Configuration Reference
in the Amazon Redshift
Developer Guide. To set workload management configuration use the
wlm_json_configuration
parameter as described in the following
Configure Workload Management Using the wlm_json_configuration
Parameter (p. 42)
section.
Note
At this time, version 1.0 of the Amazon Redshift engine is the only version, and so redshift-1.0
is the only parameter group family. The
default
parameter group and any parameter groups
that you create belong to the family redshift-1.0.
If your application requires different parameter values, you can create your own parameter group. Creating
parameter group is independent of creating clusters.You can create a parameter group before you create
a cluster. You associate a parameter group with a cluster when you create it, or you can accept the
default
parameter group.
When you create a parameter group, it will initially have the same parameter values as the
default
parameter group; however, you can modify the parameter values.
In the
default
parameter group or a new parameter group, all parameters are of the
engine-default
type, because the parameter values are preset by Amazon Redshift. When you change a parameter
value in a parameter group that you created, the parameter type changes to
user
to indicate that the
value has been modified.
For parameter groups that you create, you can modify a parameter value at any time, or you can reset
all parameter values to their defaults. You can also associate a different parameter group with a cluster.
If you modify parameter values in a parameter group that is already associated with a cluster or you
associate a different parameter group with the cluster, you must restart the cluster, or the database for
the updated parameter values to take effect. If the cluster fails and is restarted by Amazon Redshift, your
changes will be applied at that time.
Configure Workload Management Using the
wlm_json_configuration Parameter
Workload management (WLM) enables you to define multiple query queues and channel queries into the
appropriate queues at runtime. For more information about workload management, go to
Implementing
Workload Management
in the Amazon Redshift Developer Guide.
By default, a cluster is configured with one queue that can run five queries concurrently. If there are no
other query queues, Amazon Redshift assigns your queries to this queue.You can optionally create more
queues by setting the wlm_json_configuration parameter in your parameter group by specifying the
workload management configuration using JSON. For example, the following JSON represents the default
WLM configuration that sets concurrency level to 5:
{
"query_concurrency":5
}
API Version 2012-12-01
42
Amazon Redshift Management Guide
Configure Workload Management Using the
wlm_json_configuration Parameter
