Primary key table takes a lot more disk space than duplicate key table with same data

Working with Data
1

Hi all,

Using Starrocks 3.3.5, when converting two tables from duplicate key to primary key tables, I observe the size of the tables on disk is almost multipied by 3. Is that expected ? I’m using ZSTD compression, does it work too for primary key tables ?

The key is comprised of two columns : a datetime and a varchar(36)

2

ZSTD works for primary key. It may comes from the primary key index to de-duplication.