AnalyticDB:Configure parameters

Procedure

1. Log on to the AnalyticDB for PostgreSQL console.
2. In the upper-left corner of the console, select a region.
3. Find the instance that you want to manage and click the instance ID.

4. In the left-side navigation pane, click Parameters.

5. On the Modifiable Parameters tab, find the parameter that you want to modify and click the icon in the Running Value column.

6. 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. Valid values: on (default): the Orca optimizer off: the Legacy optimizer. For more information about optimizers, 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. Valid values: single (default): 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.

7. Click Submit in the upper-right corner of the Modifiable Parameters tab.

8. In the Modify Parameters message, click OK.