User guide

ValueParameter Name
0extra_float_digits
defaultmax_cursor_result_set_size
defaultquery_group
falserequire_ssl
$user, publicsearch_path
0statement_timeout
[{"query_concurrency":5}]wlm_json_configuration
Use the following topics for more information about these database parameters:
• enable_user_activity_logging parameter: Database Audit Logging (p. 215).
• max_cursor_result_set_size parameter: Configuring the Maximum Size of a Cursor Result
Set (p. 57)
• require_ssl parameter: Configure Security Options for Connections (p. 158).
• wlm_json_configuration parameter: Configuring Workload Management (p. 59).
• For the other database parameters: Configuration Reference in the Amazon Redshift Database Developer
Guide.
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.
Configuring the Maximum Size of a Cursor
Result Set
The max_cursor_result_set_size parameter defines the maximum result set size, in megabytes,
that can be stored per individual cursor. This parameter value also affects the number of concurrently
active cursors for the cluster, which enables you to configure a value that increases or decreases the
API Version 2012-12-01
57
Amazon Redshift Management Guide
Configuring the Maximum Size of a Cursor Result Set