cloud

------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- 9 nodes
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------

-- clickhouse-client output --------------------------------------------------------------------------------------------
0 rows in set. Elapsed: 1664.259 sec. Processed 65.33 billion rows, 9.60 TB (39.26 million rows/s., 5.77 GB/s.)
Peak memory usage: 231.76 GiB.

-- active parts at ingest finish
┌─parts─┐
│  4918 │
└───────┘

-- time to 3k active parts
┌─seconds─┬─parts─┐
│    2232 │  2994 │
└─────────┴───────┘


------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- 6 nodes
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------

-- clickhouse-client output --------------------------------------------------------------------------------------------
0 rows in set. Elapsed: 2466.766 sec. Processed 65.33 billion rows, 9.60 TB (26.49 million rows/s., 3.89 GB/s.)
Peak memory usage: 232.68 GiB.

-- active parts at ingest finish
┌─parts─┐
│  4468 │
└───────┘

-- time to 3k active parts
┌─seconds─┬─parts─┐
│    3081 │  2996 │
└─────────┴───────┘


------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- 3 nodes
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------

-- clickhouse-client output --------------------------------------------------------------------------------------------
0 rows in set. Elapsed: 4759.683 sec. Processed 65.33 billion rows, 9.60 TB (13.73 million rows/s., 2.02 GB/s.)
Peak memory usage: 231.84 GiB.

-- active parts at ingest finish
┌─parts─┐
│  4042 │
└───────┘

-- time to 3k active parts
┌─seconds─┬─parts─┐
│    5527 │  2996 │
└─────────┴───────┘


------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- 1 node
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------

-- clickhouse-client output --------------------------------------------------------------------------------------------
0 rows in set. Elapsed: 14700.814 sec. Processed 65.33 billion rows, 9.60 TB (4.44 million rows/s., 653.24 MB/s.)
Peak memory usage: 232.14 GiB.

-- time to 3k active parts
┌─seconds─┐
│   14700 │
└─────────┘