New Minor Version of Data Warehouse Service(DWS) offers New Features and some changed on existing ones.
New Features:
- Optimized the usability of warm backup. Warm backup is performed segment by segment to improve the stability.
- Added the function of interconnecting DWS accounts with LDAP.
- DWS features an external identity source capability, enabling user management via Light Directory Access Protocol (LDAP) and OneAccess. This allows for automatic user synchronization and database access using username/password from the external source.
- DWS supports user permission management.
- DWS allows you to manage database users on the console. You can create, delete, and update database users and manage their permissions on the console.
- DWS provides the function of managing database roles on the console.
- DWS enables monitoring and alarms for size metrics in the pg_cbm/pg_rewind_bak/pg_xlog directory.
- DWS enables monitoring and alarms for inode and size metrics in the /var/log/ system directory, as well as for the gs_profile directory.
Changed Features:
- Concurrent truncate, exchange, and select operations are supported.
- Added the GUC parameter ddl_select_concurrent_mode. This parameter is used to solve the problem that the query statement lasts for a long time and blocks DDL in the scenario where the data volume is large or the query is complex. The effect is the same as that of the Oracle database.
- Application scenarios:
- Concurrent truncate and select operations.
- Concurrent exchange and select operations.
- Scenario constraints:
- Concurrency is not supported when there are conflicts with locks of higher levels (more than one level). For example, autoanalyze is triggered by select when autoanalyze_mode is set to normal.
- Concurrency is not supported when there are conflicts with locks in transaction blocks.
- Connection constraints:
- When the JDBC, ODBC, or Python driver is used, if autocommit is set to false, this feature is not supported.
- This feature is not supported by query statements delivered by Data Studio and auto-committed transactions.
- DWS serviceability: The sequence of databases, schemas, and tables can be customized during redistribution.
- Before redistribution starts or when redistribution is paused, you can set redistribution priorities for the tables that have not been redistributed by schema or table.
- On the Redistribution Details page, you can assign priorities to suspended redistribution tasks. Once set by schema or table, redistribution follows the specified sequence.
- Concurrent task numbers can be adjusted on-the-fly, except in cluster versions before 8.1.0, which require suspension for adjustment.
- After redistribution, the average processing rate is displayed.
- Agent auto-upgrade.
- When a user delivers a cluster upgrade operation on the console, the agent is automatically upgraded to the target version.
Further information can be found in the Data Warehouse Service(DWS) area of the Help Center.