AnalyticDB for PostgreSQL allows you to configure some key kernel parameters to meet customized requirements
in various scenarios. This topic describes how to configure these parameters in the
AnalyticDB for PostgreSQL console.
Procedure
- Log on to the AnalyticDB for PostgreSQL console.
- In the top navigation bar, select the region where the instance for which you want
to configure parameters resides.
- Find the instance and click its ID to go to the Basic Information page.
- In the left-side navigation pane, click Parameter Configuration.
- Click the Edit icon next to the parameter that you want to modify, modify the value
of the parameter, and then click OK.
Parameter |
Description |
statement_timeout |
The maximum timeout period. The default value is 10800000. Unit: milliseconds. If
the timeout period exceeds the value of the parameter, the statement is terminated.
|
rds_master_mode |
The consistency model of the AnalyticDB for PostgreSQL instance. This parameter is valid only when the instance has multiple coordinator
nodes. Default value: Single. Valid values:
- Single: The instance has only a single coordinator node.
- multi_write_ec: the session consistency model. Monotonic reads, monotonic writes,
reads after writes, and writes after reads are consistent in a session.
- multi_write_sc: the global consistency model. This mode provides compatibility of
atomicity, consistency, isolation, durability (ACID) and linearizability.
|