The default values of some parameters in PolarDB for PostgreSQL(Compatible with Oracle) are modified from V1.1.28.

Background information

The default values of some parameters in PolarDB for PostgreSQL(Compatible with Oracle) are modified. The modifications are valid only for new clusters. New default values can significantly improve the performance of databases. You can modify the default values in the console.
Note You can execute the following statement to view the revision version of a PolarDB for PostgreSQL(Compatible with Oracle) cluster:
show polar_version;

Parameters

The default values are modified for the following parameters.
ParameterOriginal default valueNew default valueDescription
log_statementallddlSpecifies the level of audit logs. Default value: ddl, which indicates that only logs for DDL statements are audited. Displaying less logs can improve database performance.
Note
  • You can enable the audit log feature on the SQL Explorer page of the console. Then, logs for all SQL statements are audited. For more information, see SQL Explorer.
  • You can execute the following statement to view the settings of this parameter for the current cluster:
    show log_statement;
Note For more information about the default values of other parameters, see Default values of cluster parameters.