GaussDB(DWS) Technical Specifications¶
This section describes the technical specifications of GaussDB(DWS) in different versions.
Technical Specifications | Maximum Value of 8.1.3 | Maximum Value of 8.2.0 | Maximum Value of 8.2.1 | Maximum Value of 8.3.0 |
|---|---|---|---|---|
Number of cluster nodes | 2048 | 2048 | 2048 | 2048 |
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 concurrent complex queries in minutes: 80 Number of short queries in seconds: 500 Number of concurrent short transactions in milliseconds: 5000 |
Cluster data capacity | 20 PB | 20 PB | 20 PB | 20 PB |
Size of a single table | 1 PB | 1 PB | 1 PB | 1 PB |
Size of data in each row | 1 GB | 1 GB | 1 GB | 1 GB |
Number of columns in a single table: (excluding Hudi tables) | 1600 | 1600 | 1600 | 1600 |
Number of columns in a Hudi table |
|
| 5000 | 5000 |
Number of partitions of the partitioned table | 32,768 | 32,768 | 32,768 | 32,768 |
RTO after a SPOF | 60s | 60s | 60s | 60s |
RPO after a SPOF | 0 | 0 | 0 | 0 |
RTO after cluster DR switchover | 60min | 60min | 60min | 60min |
RPO after cluster DR switchover | 60min | 60min | 60min | 60min |
Technical Specifications | Maximum Value of 8.0.x | Maximum Value of 8.1.0 | Maximum Value of 8.1.1 |
|---|---|---|---|
Data capacity | 10 PB | 10 PB | 20 PB |
Number of cluster nodes | 256 | 256 | 2048 |
Size of a single table | 1 PB | 1 PB | 1 PB |
Size of data in each row | 1 GB | 1 GB | 1 GB |
Size of a single column in each record | 1 GB | 1 GB | 1 GB |
Number of records in each table | 255 | 255 | 255 |
Number of columns in each table | 1600 | 1600 | 1600 |
Number of indexes in each table | Unlimited | Unlimited | Unlimited |
Number of columns in the index of each table | 32 | 32 | 32 |
Number of constraints in each table | Unlimited | Unlimited | Unlimited |
Number of concurrent connections | Number of concurrent complex queries in minutes: 60 Number of concurrent short transactions in milliseconds: 5000 | Number of concurrent complex queries in minutes: 60 Number of concurrent short transactions in milliseconds: 5000 | Number of concurrent complex queries in minutes: 80 Number of concurrent short transactions in milliseconds: 5000 |
Number of partitions in a partitioned table | 32,768 | 32,768 | 32,768 |
Size of each partition in a partitioned table | 1 PB | 1 PB | 1 PB |
Number of records in each partition in a partitioned table | 255 | 255 | 255 |
Note
The maximum number of concurrent connections is based on the data warehouse with the cloud disk flavor of 48 vCPUs or 64 vCPUs. For example, dwsk.12xlarge (48 vCPU | 384GB | 24000GB SSD) or dwsx2.16xlarge.m7 (64 vCPU | 512GB | 32000GB SSD) of a standard data warehouse.