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. Find the parameter that you want to modify and click the icon in the Running Value column.

6. In the dialog box that appears, modify the parameter value and click OK. The following table describes the parameters and their valid values.

   Parameter	Description
   optimizer	Sets the optimizer for the AnalyticDB for PostgreSQL instance. on: Uses the Orca optimizer. This is the default. off: Uses the Legacy optimizer. For more information about how to select an optimizer, see Optimize query performance.
   statement_timeout	Sets the timeout period for SQL statements on the AnalyticDB for PostgreSQL instance. If a statement exceeds the timeout period, it is terminated. The value is measured in milliseconds and can range from 0 to 86400000. The default value is 10800000.
   rds_master_mode	Sets the consistency mode for the AnalyticDB for PostgreSQL instance. single: Applies to single-coordinator-node scenarios. This is the default. multi_write_ec (session consistency): Guarantees monotonic reads, monotonic writes, read-your-writes, and writes-follow-reads consistency within the same session. multi_write_sc (global consistency): Provides full ACID compliance and linearizability guarantees. Note This setting takes effect only when the instance has multiple coordinator nodes.

7. In the upper-right corner of the page, click Submit.

8. In the Modify Parameters dialog box, click OK.