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

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select the region where the instance resides.
  3. Find the instance that you want to manage and click its ID.
  4. In the left-side navigation pane, click Parameter Configuration.
  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. 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.
  7. Click Submit in the upper-right corner of the Modifiable Parameters tab.
  8. In the Parameter Modification message, click OK.