User guide

Amazon Redshift Parameter
Groups
Topics
• Overview (p. 56)
• Configuring the Maximum Size of a Cursor Result Set (p. 57)
• Configuring Workload Management (p. 59)
• Managing Parameter Groups Using the Console (p. 72)
• Managing Parameter Groups Using the AWS SDK for Java (p. 77)
• Managing Parameter Groups Using the Amazon Redshift CLI and API (p. 80)
Overview
When you provision an Amazon Redshift cluster, you associate a parameter group with it.The parameters
in the group apply to all the databases you create on the cluster. The Amazon Redshift engine provides
a default parameter group, which has preset values for the parameters.You cannot change the values
in the default parameter group. The default parameter group is named default.redshift-version.
For example, default.redshift-1.0.
The list of parameters available in a parameter group depends on the parameter group family to which
it belongs. A parameter group family refers to the Amazon Redshift engine version. For example, parameter
group family "redshift-1.0" identifies Amazon Redshift engine version 1.0. Parameter groups in this family
have a specific set of parameters for a specific Amazon Redshift version. The following table lists the
parameters and their values in the default parameter group in the redshift-1.0 parameter group family.
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.
ValueParameter Name
ISO, MDYdatestyle
falseenable_user_activity_logging
API Version 2012-12-01
56
Amazon Redshift Management Guide
Overview