Updated on 2023-03-30 GMT+08:00

Technical Specifications

Software Specifications

Table 1 lists the technical specifications of GaussDB(DWS).

Table 1 Technical specifications

Technical Specifications

Maximum Value

Data capacity

20 PB

Number of cluster nodes

2048

Size of a single table

1 PB

Size of data in each row

1 GB

Size of a single column in each record

1 GB

Number of records in each table

255

Number of columns in each table

1,600

Number of indexes in each table

Unlimited

Number of columns in the index of each table

32

Number of constraints in each table

Unlimited

Number of concurrent connections

80 for analytical long transactions, 500 for online short queries, and 5000 for short transactions

Number of partitions in a partitioned table

32,768

Size of each partition in a partitioned table

1 PB

Number of records in each partition in a partitioned table

255

Product Performance

Table 2 lists the performance specifications of GaussDB(DWS).

Table 2 GaussDB performance

Performance

Data import: 80 MB/s for row-store tables and 150 MB/s for column-store tables per node

Server configurations:

CPU: 2 x 12-core Intel Xeon E5-2690 CPUs

Memory: 256 GB

Disk: 20 x 600 GB SAS disks

Network: 10GE

Data export: 100 MB/s per node

Full table scan: 300 million records per second

Point query: precise query of trillions of records in seconds

GROUP BY: 20 million records per second per node

JOIN: 5 million records per second per node

ORDER BY: 3 million records per second per node