I have a table that contains two columns:
CREATE TABLE processLog (
url STRING NOT NULL,
CONSTRAINT “primary” PRIMARY KEY (url asc)
There are only 47 Rows within this table but the BYTES value of every row gets updated every 5 minutes with roughly 3 kB of data. Within roughly one day the table has grown to 104.6 MiB in size. It seems like cockroach stores every version of every row. Is this correct? Is there anything I can do to make sure such a table doesn’t grow out of proportion?