Open Telekom Cloud for Business Customers

Data Warehouse Service New Features

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.


Do you have questions?

We answer your questions about testing, booking and use – free of charge and individually. Try it! 
Hotline: 24 hours a day, 7 days a week
0800 3304477 from Germany / 00800 33044770 from abroad

  • Communities

    The Open Telekom Cloud Community

    This is where users, developers and product owners meet to help each other, share knowledge and discuss.

    Discover now

  • Telefon

    Free expert hotline

    Our certified cloud experts provide you with personal service free of charge.

     0800 3304477 (from Germany)

    +800 33044770 (from abroad)

    24 hours a day, seven days a week

  • E-Mail

    Our customer service is available free of charge via E-Mail

    Write an E-Mail

  • AI Chat


    Our AI-powered search helps with your cloud needs.