Help Center/ GaussDB(DWS)/ Performance White Paper (9.1.0.x)/ TPC-DS Performance Test/ TPC-DS Test Process/ TPC-DS Test Data
Updated on 2025-07-22 GMT+08:00
View PDF
Share

TPC-DS Test Data

Table 1 TPC-DS test data

No.

Table Name

Number of Rows

Table Size

1

customer_address

6,000,000

126 MB

2

customer_demographics

1,920,800

11 MB

3

date_dim

73,049

11 MB

4

warehouse

20

1,200 KB

5

ship_mode

20

864 KB

6

time_dim

86,400

1,520 KB

7

reason

65

720 KB

8

income_band

20

720 KB

9

item

300,000

23 MB

10

store

1,002

2,400 KB

11

call_center

42

1,968 KB

12

customer

12,000,000

519 MB

13

web_site

54

1,824 KB

14

household_demographics

7,200

1,208 KB

15

web_page

3,000

2,208 KB

16

promotion

1,500

2,112 KB

17

catalog_page

30,000

3,536 KB

18

inventory

783,000,000

2,499 MB

19

catalog_returns

143,996,756

8,454 MB

20

web_returns

71,997,522

3,990 MB

21

store_returns

287,999,764

13 GB

22

web_sales

720,000,376

54 GB

23

catalog_sales

1,439,980,416

104 GB

24

store_sales

2,879,987,999

142 GB
Parent topic: TPC-DS Test Process