Technical 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	2⁵⁵
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	2⁵⁵

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