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.
| Parameter | Original default value | New default value | Description |
|---|---|---|---|
| log_statement | all | ddl | Specifies 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
|
Note For more information about the default values of other parameters, see Default values of cluster parameters.