1

8.0.0.3 kernel version

The following issues are resolved or optimized:

• Internal invoking of system functions.
• Result set is duplicate when a column-based table is queried using the in expression.
• Core issues related to the sublink pull-up occur in the target list.
• Out of memory error occurs on the CN because the insert into select statement is not pushed down.
• Error occurs when data imported using GDS contains \0.
• Error occurs when the JDBC driver executes the SQL statement with the in condition.
• Memory bloat occurs when the audit function pgxc_query_audit is executed.
• GBK data in the fixed format is inconsistent when imported to the UTF8 database.

Commercial use

-

2

Added the second generation of the EVS storage type. Users can set the storage type and storage capacity.

When creating a cluster, you can select Second Generation as required. This flavor is used for EVS disks. You can set the storage type and storage capacity, and storage resources are billed independently.

Commercial use

Creating Clusters

3

Added yearly/monthly packages for storage.

You can select the package type as capacity or node.

Commercial use

Buying Yearly/Monthly Packages

4

Added the help panel on the console.

When you log in to the console to use GaussDB(DWS), you can view instructions on the help panel to quickly understand related application scenarios, best practices, and FAQs.

Commercial use

-

1

Real-time data warehouse

GaussDB(DWS) supports real-time data warehouses.

Beta test

Create Service Ticket to apply for OBT.

2

Workload management

Workload management enables concurrent and independent execution of two types of jobs.

Commercial use

Managing Cluster Workloads

3

gs_dump, gs_dumpall

• gs_dump: Exports a single database or its objects.
• gs_dumpall: Exports all databases in a cluster or common global objects each database.

Commercial use

Using gs_dump and gs_dumpall to Export Data

1

Fine-grained permission control

The IAM service provides fine-grained access control.

On IAM, the administrator (that is, a user in the admin user group) can create a custom policy containing various required permissions. After a policy is granted to a user group, users in the group can obtain all permissions defined by the policy.

Commercial use

Fine-Grained Policies

2

Canceling read-only status on the console

The read-only status of a cluster can be canceled on the management console. Only v1.7.2 or later support this feature.

Commercial use

Canceling Read-only Status

1

Kunpeng cluster

Added the support for Kunpeng KC and KM series flavors.

Commercial use

-

2

DSC tool

Brought the DSC tool online and brought the Migration Tool and Schema Convert Tool offline.

Commercial use

-

3

Updated database kernel functions

• UPDATE supported alias and table name reference.
• You can specify a schema during index creation. The specified schema must be the same as that where the base table resides.
• Added the alter table modify null/not null syntax.
• Added the support for the alter sequence maxvalue operation.
• Limited the temporary tablespace and operator disk flushing space.
• Removed the sub-statement records from TopSQL.
• Added the support for recording lightweight CN statements.
• Processed the aging data in the historical TopSQLinfo table.
• CN Retry supported stored procedures and function statements.

Commercial use

-

1

Permission name change

Changed the name of the DWS Viewer policy to DWS ReadOnlyAccess, and that of the DWS Admin policy to DWS FullAccess.

Commercial use

-

1

Automatic parameter tuning

GaussDB(DWS) supports the automatic parameter tuning.

GaussDB(DWS) uses the deep learning algorithms to perform automatic training based on typical service scenarios specified by users. After the training, the system obtains a group of optimal parameters that can be used for cluster configuration. In this way, users can be freed from complex parameter configuration, and the cluster configuration is more suitable for actual scenarios.

Beta test

• Performing Automatic Parameter Tuning
• Create Service Ticket to apply for OBT.

2

Added the request parameter Enterprise Project.

Added the Enterprise Project parameter to the API.

Commercial use

-