For a simple table with 4 bigint columns, 2 of which form the primary key:
CREATE TABLE test( a bigint, b bigint, c bigint, d bigint, PRIMARY KEY((a), b)
Tried to measure the on-disk space usage using a replication factor 1
setup (created using yb-ctl). This was tried using 2.1.6 version on Linux.
./bin/yb-ctl destroy ./bin/yb-ctl start
Then loaded the above table with 1 million rows (1000 distinct values for column “a”, each with 1000 distinct values for “b” and random values for c and d).
Then looked at space utilized:
% du -sh ./yb-data/tserver 410M ./yb-data/tserver
This seems to suggest that each row takes about 410 bytes. Note that the system does not have any other tables.
This seems on the high side. Is this a correct way of measuring the space utilized?