Updated on 2025-12-10 GMT+08:00

DWS Technical Specifications

This section describes the technical specifications of DWS in different versions.

Table 1 Technical specifications of DWS 8.1.3 – 9.1.0

Technical Specifications

Maximum Value of 8.1.3

Maximum Value of 8.2.1

Maximum Value of 8.3.0

Maximum Value of 9.1.0

Number of cluster nodes

2048

2048

2048

  • Storage-compute integration: 2048
  • Decoupled storage and compute: The multi-VW technology is used to support up to 256 VWs, each with up to 1,024 DNs. It is recommended that you limit VWs to 32 or fewer and DNs to 128 or fewer per VW. The total number of DNs of all VWs cannot exceed 2,048.

Number of databases for an instance

Less than 10 (recommended)

Less than 10 (recommended)

Less than 10 (recommended)

Less than 10 (recommended)

Number of concurrent connections

Number of concurrent complex queries in minutes: 80

Number of short queries in seconds: 500

Number of concurrent short transactions in milliseconds: 5000

Number of concurrent complex queries in minutes: 80

Number of short queries in seconds: 500

Number of concurrent short transactions in milliseconds: 5000

Number of concurrent complex queries in minutes: 80

Number of short queries in seconds: 500

Number of concurrent short transactions in milliseconds: 5000

Number of short queries in seconds: 500

Number of concurrent short transactions in milliseconds: 5000

  • Coupled storage and compute:

    Number of concurrent complex queries in minutes: 80

    Number of short queries in seconds: 500

    Number of concurrent short transactions in milliseconds: 5000

  • Decoupled storage and compute:

    The multi-VW technology can increase the number of concurrent requests. As the number of VWs increases, the number of concurrent requests can be increased accordingly. The total number of concurrent requests in a cluster is affected by the GTM/CCN queuing. The maximum number is 32,768. It is recommended that the number be no more than 8,192 (default value).

Cluster data capacity

20 PB

20 PB

20 PB

  • Coupled storage and compute: 20 PB
  • Decoupled storage and compute: Data is stored on OBS. Theoretically, the capacity can be expanded infinitely.

Size of a single table

1 PB

1 PB

1 PB

1 PB

Size of data in each row

Less than 1 GB (related to the column type and number of columns)

Less than 1 GB (related to the column type and number of columns)

Less than 1 GB (related to the column type and number of columns)

Less than 1 GB (related to the column type and number of columns)

Number of columns in a table (excluding Hudi tables)

Row store: 1,600 (including deleted columns). A data row (tuple) must be able to fit into a database page (8 KB).

Others: 1,600

Row store: 1,600 (including deleted columns). A data row (tuple) must be able to fit into a database page (8 KB).

Others: 1,600

Row store: 1,600 (including deleted columns). A data row (tuple) must be able to fit into a database page (8 KB).

Others: 1,600

Row store: 1,600 (including deleted columns). A data row (tuple) must be able to fit into a database page (8 KB).

Others: 1,600

Number of indexes in each table

There is no limit. A number no larger than 5 is recommended.

There is no limit. A number no larger than 5 is recommended.

There is no limit. A number no larger than 5 is recommended.

There is no limit. A number no larger than 5 is recommended.

Hybrid data warehouse: A primary key or a unique index, and no more than three secondary indexes are recommended.

Number of columns in the index of each table

32. A number no larger than 5 is recommended. Fields with a fixed length provide the best performance.

32. A number no larger than 5 is recommended. Fields with a fixed length provide the best performance.

32. A number no larger than 5 is recommended. Fields with a fixed length provide the best performance.

32. A number no larger than 5 is recommended. Fields with a fixed length provide the best performance.

Number of columns in a Hudi table

N/A

5000

5000

5000

Number of partitions of the partitioned table

32767. A number no larger than 1,000 is recommended.

32767. A number no larger than 1,000 is recommended.

32767. A number no larger than 1,000 is recommended.

32767. A number no larger than 1,000 is recommended.

Size of each partition in a partitioned table

1 PB

1 PB

1 PB

1 PB

RTO after a SPOF

60s

60s

60s

60s

RPO after a SPOF

0

0

0

0

RTO after cluster DR switchover

60 min

60 min

60 min

60 min

RPO after cluster DR switchover

60 min

60 min

60 min

60 min

  • A virtual warehouse (VW) refers to a logical cluster. In the architecture with decoupled storage and compute, a DWS physical cluster can be split into multiple VWs. Different services can be bound to different VWs to isolate service loads and increase the number of concurrent requests.
  • The maximum number of concurrent connections is based on the data warehouse flavor of 48 vCPUs or 64 vCPUs. For example, you can choose dwsk.12xlarge (48 vCPU | 384GB | 24000GB SSD) or dwsx2.16xlarge.m7 (64 vCPU | 512GB | 32000GB SSD) for a storage-compute coupled data warehouse.