AnalyticDB for PostgreSQL allows you to configure specific parameters to meet requirements in a variety of scenarios. This topic describes how to configure parameters in the AnalyticDB for PostgreSQL console.
Procedure
- Log on to the AnalyticDB for PostgreSQL console.
- In the upper-left corner of the console, select the region where the instance resides.
- Find the instance that you want to manage and click its ID.
- In the left-side navigation pane, click Parameter Configuration.
- On the Modifiable Parameters tab, find the parameter that you want to modify and click the icon in the Running Value column.
- In the dialog box that appears, enter a new value and click OK. The following table describes the parameters.
Parameter Description optimizer The optimizer of the AnalyticDB for PostgreSQL instance. Default value: on. Valid values: - on: the ORCA optimizer
- off: the Legacy optimizer
For more information about how to select an optimizer, see Optimize query performance.
statement_timeout The timeout period of SQL statements for the AnalyticDB for PostgreSQL instance. If an SQL statement is executed for a period longer than the timeout period, the statement is terminated. Valid values: 0 to 86400000. Unit: milliseconds. Default value: 10800000.
rds_master_mode The consistency mode of the AnalyticDB for PostgreSQL instance. 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 within a session.
- multi_write_sc: the global consistency model. This mode provides atomicity, consistency, isolation, durability (ACID) and linearizability.
Note This parameter is valid only when the instance has multiple coordinator nodes. - Click Submit in the upper-right corner of the Modifiable Parameters tab.
- In the Parameter Modification message, click OK.