检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Range N/A component_names String Definition Component information on the node (for example, component ID:distributed ID). Separate information of multiple components with semicolons (;).
Value range: enumerated values on (true, yes, 1): The primary node waits for the standby node to flush logs to disks before committing a transaction. off (false, no, 0): The primary node commits a transaction without waiting for the primary node to flush logs to disks.
There are six value options, namely, any, master, slave, preferSlave, read-write, and read-only. The default value is any. any: attempts to connect to any DN in the URL connection string. master: attempts to connect to a primary node in the URL connection string.
Node group name (when enable_nodegroup_debug is set to on): A specific node group is used as the compute node group.
The public_cloud.conf file contains the following NIC information: mgr.net (management NIC), data.net (data NIC), and virtual.net (virtual NIC). local_bind_address Parameter description: Specifies the host IP address bound to the current node for connecting to other nodes in the database
); 200 (32-core CPU/256-GB memory) DN: 8000 (96-core CPU/768-GB memory); 5000 (72-core CPU/576-GB memory); 4000 (64-core CPU/512-GB memory); 1000 (32-core CPU/256-GB memory) Impact of incorrect configuration: If the value of max_connections exceeds the maximum dynamic value, the node
(The logs do not need to be flushed to disks.) remote_receive: The primary node waits for the standby node to receive logs before committing a transaction.
Property type: Boolean Value range: true: If the close() method is not called, the finalize() method will be used to close the corresponding connection object. false: If the close() method is not called, the corresponding connection object will not be closed.
SELECT xmlconcat(xmlcomment('hello'), xmlelement(NAME qux, 'xml'), xmlcomment('world')); xmlconcat ---------------------------------------- <!
SELECT xmlconcat(xmlcomment('hello'), xmlelement(NAME qux, 'xml'), xmlcomment('world')); xmlconcat ---------------------------------------- <!
There are six value options, namely, any, master, slave, preferSlave, read-write, and read-only. The default value is any. any: attempts to connect to any DN in the URL connection string. master: attempts to connect to a primary node in the URL connection string.
Default value: any Query statement: select local_role, db_state from pg_stat_get_stream_replications(); Suggestion: You are advised to set this parameter to master for services with write operations to ensure that the primary node can be properly connected after a primary/standby
[10,200] [10,200] [64 GB,128 GB) [10,1000] [10,2500] [128 GB,256 GB) [10,2000] [10,6000] [256 GB,480 GB) [10,4000] [10,12000] ≥ 480 GB [10,8000] [10,24000] Default value: Independent deployment: CN: 8000 (60-core CPU/480 GB memory); 4000 (32-core CPU/256 GB memory); 2000 (16-core
[10,200] [10,200] [64GB,128GB) [10,1000] [10,2500] [128GB,256GB) [10,2000] [10,6000] [256GB,480GB) [10,4000] [10,12000] ≥ 480 GB [10,8000] [10,24000] Table 2 Value ranges of memory specifications for different instances in hybrid deployment mode Memory Specifications Value Range for
Return type: bigint pg_stat_get_backend_idset() Description: Sets the number of currently active server processes (from 1 to the number of active server processes).
There are six value options, namely, any, master, slave, preferSlave, read-write, and read-only. The default value is any. any: attempts to connect to any DN in the URL connection string. master: attempts to connect to a primary node in the URL connection string.
Return type: bigint pg_stat_get_backend_idset() Description: Sets the number of currently active server processes (from 1 to the number of active server processes).
openGauss=# View the allowed maximum connections. 1 2 3 4 5 openGauss=# SHOW max_connections; max_connections ----------------- 200 (1 row) Run the following command to exit the database: 1 openGauss=# \q Change the maximum connections for the primary database node in GaussDB
Property type: Boolean Value range: true: If the close() method is not called, the finalize() method will be used to close the corresponding Connection object. false: If the close() method is not called, the corresponding Connection object will not be closed.
Log sending speed (MB/s). Log read speed (MB/s). Log parsing speed (MB/s). Constraints: For parallel decoding, only the parallel decoding performance views of the primary nodes for centralized instances are provided. Distributed logical decoding is supported.
