检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
This parameter must be enabled for the multi-tenant database feature (enable_mtd). Fixed cost exists, that is, shared_buffers and metadata (about 200 MB). If max_process_memory minus the fixed cost is less than 2 GB, GaussDB forcibly sets enable_memory_limit to off.
f_int2) ( slice s1 values less than (100, 100) datanode (datanode1,datanode2), slice s2 values less than (200, 200) datanode datanode2, slice s3 values less than (300, 300) datanode datanode2, slice s4 values less than (maxvalue, maxvalue) datanode (datanode1,datanode2
If the number of nodes exceeds 7, increase the value of this parameter (for example, to 40). Otherwise, the primary node may remain in the promoting state and the log replication between the primary and standby nodes has no progress. This is a POSTMASTER parameter.
NOCOMPRESS Non-reserved N/A N/A NOCYCLE Reserved N/A N/A NODE Non-reserved N/A N/A NOENTITYESCAPING Non-reserved N/A N/A NOLOGGING Non-reserved N/A N/A NOMAXVALUE Non-reserved N/A N/A NOMINVALUE Non-reserved N/A N/A NONE Non-reserved (cannot be functions or types) Reserved N/A NOT
NOCOMPRESS Non-reserved N/A N/A NOCYCLE Reserved N/A N/A NODE Non-reserved N/A N/A NOENTITYESCAPING Non-reserved N/A N/A NOLOGGING Non-reserved N/A N/A NOMAXVALUE Non-reserved N/A N/A NOMINVALUE Non-reserved N/A N/A NONE Non-reserved (cannot be functions or types) Reserved N/A NOT
Check whether the storage space is a multiple of 10. 400 DBS.280611 The storage space must be a multiple of (Number of shards x 40 GB). The storage space must be a multiple of (Number of shards x 40 GB).
Unit: none Value range: 0 to 262143 Default value: Independent deployment: 1200 (60-core CPU/480 GB memory and 32-core CPU/256 GB memory); 800 (16-core CPU/128 GB memory); 400 (8-core CPU/64 GB memory); 300 (4-core CPU/32 GB memory); 200 (4-core CPU/16 GB memory) Setting method: This
Identifier Naming Conventions Identifier naming must comply with the following rules: An identifier name can only contain letters, digits (0–9), underscores (_), and dollar signs ($). An identifier name must start with a letter or an underscore (_).
Identifier Naming Conventions Identifier naming must comply with the following rules: An identifier name can only contain letters, digits (0–9), underscores (_), and dollar signs ($). An identifier name must start with a letter or an underscore (_).
Grant the retrieve permission of r_reason_sk, r_reason_id, and r_reason_desc columns and the UPDATE permission of the r_reason_desc column in the tpcds.reason table to joe. 1 openGauss=# GRANT select (r_reason_sk,r_reason_id,r_reason_desc),update (r_reason_desc) ON tpcds.reason TO
GB memory); 200 GB (32-core CPU/256 GB memory); 90 GB (16-core CPU/128 GB memory); 40 GB (8-core CPU/64 GB memory); 20 GB (4-core CPU/32 GB memory); 10 GB (4-core CPU/16 GB memory) Setting suggestions: The value on the database node is determined based on the physical memory of the
JSON_MERGE(), JSON_REMOVE(), JSON_REPLACE(), JSON_SET(), JSON_DEPTH(), JSON_LENGTH(), JSON_TYPE(), JSON_VALID(), JSON_ARRAY_APPEND(), benchmark(), FROM_BASE64(), TO_BASE64(), make_set(), mid(), ord(), conv(), crc32(), system_user(), password(), IS_IPV4(), IS_IPV6(), sleep(), bin()
Default value: Independent deployment: 1200 (60-core CPU/480 GB memory and 32-core CPU/256 GB memory); 800 (16-core CPU/128 GB memory); 400 (8-core CPU/64 GB memory); 300 (4-core CPU/32 GB memory); 200 (4-core CPU/16 GB memory) To avoid failures in the preparation step, the value
TO { GROUP groupname | NODE ( nodename [, ... ] ) } TO GROUP specifies the node group to which the table to be created belongs. TO NODE is used for internal scale-out tools. CONSTRAINT constraint_name Specifies the name of a column or table constraint.
row) Example 3 NULLIF use cases: -- Create the gsloader_test_nullif table. gaussdb=# create table gsloader_test_nullif( col1 varchar2(100) not null enable, col2 number(5,0) not null enable, col3 varchar2(200) not null enable, col4 varchar2(34) not null enable, col5 varchar2
Default value: Independent deployment: 360 GB (60-core CPU/480 GB memory); 192 GB (32-core CPU/256 GB memory); 96 GB (16-core CPU/128 GB memory); 40 GB (8-core CPU/64 GB memory); 20 GB (4-core CPU/32 GB memory); 10 GB (4-core CPU/16 GB memory) Finance edition (standard): CN: 200 GB
Parameter type: Integer Unit: None Value range: 0 and 1 0: The stored procedures, anonymous blocks, or user-defined functions (excluding system functions) are not audited. 1: The stored procedures, anonymous blocks, or user-defined functions (excluding system functions) are audited
Multiple items are separated by commas (,).
(Minimum specifications for the destination instance: 8 vCPUs | 32 GB) The backup media, CPU architecture, OS type and version, instance type (distributed or centralized), deployment model, replica consistency protocol, and transaction consistency settings of the new instance must
This model is only available for instances of V2.0-3.200 or later. This option is available only when Resource Type is set to Elastic Cloud Server (ECS). CAUTION: Single: The availability (or SLA) cannot be guaranteed because the instance is deployed on a single server.
